Project

General

Profile

« Previous | Next » 

Revision 14013

Added by Aaron Marcuse-Kubitza over 10 years ago

config/VirtualBox_VMs/vegbiendev/README.TXT: added steps to create snapshot before running pg_restore

View differences:

trunk/config/VirtualBox_VMs/vegbiendev/README.TXT
32 32 
screen
33 33 
# press ENTER
34 34 
l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 35 min ("0:32:34")
35 
# press Ctrl-D
36 
sudo halt
37 
# at "System halted", close the VM and *uncheck* Restore current snapshot
38 
# create a VM snapshot named "+initdb+database backup"
39 
# boot the VM
40 
# when asked whether to skip mounting, press S
41 
ssh -t 128.111.220.240
42 
screen
43 
# press ENTER
35 44 
for schema in temp util py_util geoscrub herbaria IRMNG IUCN NCBI newWorld TNRS ARIZ; do
36 45 
	bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";"
37 46 
	"time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup

Also available in: Unified diff