Project

General

Profile

« Previous | Next » 

Revision 14015

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: config/VirtualBox_VMs/vegbiendev/README.TXT: pg_restore: need to run as DB superuser to restore py_util

View differences:

trunk/config/VirtualBox_VMs/vegbiendev/README.TXT
33 33 
# press ENTER
34 34 
l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 25 min ("0:25:24")
35 35 
# press Ctrl-D
36 
sudo chgrp postgres backups/vegbien.r12025.backup
36 37 
sudo halt
37 38 
# at "System halted", close the VM and *uncheck* Restore current snapshot
38 39 
# create a VM snapshot named "+initdb+database backup"
......
43 44 
# press ENTER
44 45 
for schema in temp util py_util geoscrub herbaria IRMNG IUCN NCBI newWorld TNRS ARIZ; do
45 46 
	bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";"
46 
	"time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup
47 
	"time" sudo -E -u postgres pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup
48 
		# need to run as DB superuser to restore py_util
47 49 
done
48 50 
	# must use for loop because pg_restore doesn't support multiple --schema
49 51 
	# options (it just uses the last one)

Also available in: Unified diff