Revision 13998
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/config/VirtualBox_VMs/vegbiendev/README.TXT | ||
|---|---|---|
| 20 | 20 |
* to use a database backup: |
| 21 | 21 |
# {
|
| 22 | 22 |
l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 13 min ("0:12:34")
|
| 23 |
"time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema=analytical_db --schema=geoscrub --schema=herbaria --schema=IRMNG --schema=IUCN --schema=NCBI --schema=newWorld --schema=py_util --schema=temp --schema=TNRS --schema=util --schema=ARIZ backups/vegbien.r12025.backup |
|
| 23 |
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 |
|
| 24 |
# must use for loop because pg_restore doesn't support multiple --schema |
|
| 25 |
# options (it just uses the last one) |
|
| 26 |
# (http://postgresql.1045698.n5.nabble.com/pg-restore-should-accept-multiple-t-switches-td2399138.html) |
|
| 24 | 27 |
# ... |
| 25 | 28 |
# } |
| 26 | 29 |
* to use a clean database: |
Also available in: Unified diff
bugfix: config/VirtualBox_VMs/vegbiendev/README.TXT: to test the import: database backup approach: pg_restore: need to use for loop because pg_restore doesn't support multiple --schema options (it just uses the last one)