mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

Merge authors:
  Dan MacNeil (omacneil)
Related merge proposals:
  https://code.launchpad.net/~omacneil/mvhub/update_push_to_production_checklist-2010-04-22/+merge/23954
  proposed by: Dan MacNeil (omacneil)
  review: Approve - Lee Goodrich (leegoodrich)
------------------------------------------------------------
revno: 369 [merge]
committer: Dan MacNeil <dan@xxxxxxxxxx>
branch nick: trunk
timestamp: Fri 2010-04-23 17:24:56 -0400
message:
  merged update_push_to_production_checklist-2010-04-22 
modified:
  app-mvhub/doc/checklists/move_to_production.txt


--
lp:mvhub
https://code.launchpad.net/~mvhub-dev/mvhub/trunk

Your team mvhub-dev is subscribed to branch lp:mvhub.
To unsubscribe from this branch go to https://code.launchpad.net/~mvhub-dev/mvhub/trunk/+edit-subscription

=== 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-23 21:18:30 +0000
@@ -81,23 +81,30 @@
 
 	___ Pull the new release into Staging
 		
-		ssh penguin.inside
+		ssh staging.inside
 		cd /var/www/mvhub/www-data/source-code/release
 		sudo su www-data -c "bzr pull"
 
 	___  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.
+		
+		# determine latest backup
+		# files are dumped in pattern
+		#	yyyy-mm-dd-Fri_mvh_production_db.dump		
+		# 	yyyy-mm-dd-Fri_mvh_production_db.sql
+		# where yyyy is year mm is 2 digit month, etc, etc
+		ls /var/backups/postgres/
+		
+		scp /var/backups/postgresql/<latest dump file>.sql \
+			pengiun.inside
 
+		ssh staging.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
@@ -106,7 +113,7 @@
 	____ handle schema changes
 
 	____run mv_setup to handle conf file changes
-		ssh penguin.inside
+		ssh staging.inside
 		sudo su www-data -l
 		cdw
 		
@@ -131,7 +138,7 @@
 ____ move to production
 
 	___ update release branch in production
-		ssh parrot.inside
+		ssh production.inside
 		cd  /var/www/mvhub/www-data/source-code/release/
 		sudo su www-data -c 'bzr pull'