mvhub-dev team mailing list archive

[Dan MacNeil <dan@xxxxxxxxxx>]

Dan MacNeil has proposed merging lp:~omacneil/mvhub/update_push_to_production_checklist-2010-04-22 into lp:mvhub.

Requested reviews:
  mvhub-dev (mvhub-dev)


see commit msg
-- 
https://code.launchpad.net/~omacneil/mvhub/update_push_to_production_checklist-2010-04-22/+merge/23954
Your team mvhub-dev is subscribed to branch lp:mvhub.

=== modified file 'app-mvhub/doc/checklists/move_to_production.txt'
--- app-mvhub/doc/checklists/move_to_production.txt	2010-04-06 22:11:26 +0000
+++ app-mvhub/doc/checklists/move_to_production.txt	2010-04-22 19:17:15 +0000
@@ -87,17 +87,17 @@
 
 	___  put production data into staging database
 
-		ssh brave.inside
+		ssh csl-db-02.inside
 		cd
-		# export production data
-        pg_dump --format=p --no-owner --clean --column-inserts \
-                --no-acl   --file production_dump-$RELEASE_TAG.sql \
-                -h localhost -U production -d production.nsp 
-		# You will have to type in the production database password.
+		# 
+		scp /var/backups/postgresql/$LATEST_DUMP_FILE.sql \
+			pengiun.inside
 
+		ssh pengiun.inside
 		# import production data
+        
         psql -h localhost -U staging -d staging.nsp -f \
-             production_dump-$RELEASE_TAG.sql > /dev/null
+             $LATEST_DUMP_FILE.sql > /dev/null
 		
 		# After executing the previous command, you may recieve three
 		# error messages concerning the public schema. These can be