Revision 14004
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/config/VirtualBox_VMs/vegbiendev/README.TXT | ||
|---|---|---|
| 23 | 23 |
* to use a database backup: |
| 24 | 24 |
# {
|
| 25 | 25 |
l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 35 min ("0:32:34")
|
| 26 |
for schema in analytical_db geoscrub herbaria IRMNG IUCN NCBI newWorld py_util temp TNRS util ARIZ; do "time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup; done |
|
| 26 |
for schema in analytical_db geoscrub herbaria IRMNG IUCN NCBI newWorld py_util temp TNRS util ARIZ; do |
|
| 27 |
bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";" |
|
| 28 |
"time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup |
|
| 29 |
done |
|
| 27 | 30 |
# must use for loop because pg_restore doesn't support multiple --schema |
| 28 | 31 |
# options (it just uses the last one) |
| 29 | 32 |
# (http://postgresql.1045698.n5.nabble.com/pg-restore-should-accept-multiple-t-switches-td2399138.html) |
Also available in: Unified diff
bugfix: config/VirtualBox_VMs/vegbiendev/README.TXT: pg_restore: need to create the schema before you restore into it, to avoid cryptic error messages