Revision 14007
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
|
|
| 26 |
for schema in geoscrub herbaria IRMNG IUCN NCBI newWorld py_util temp TNRS util ARIZ; do |
|
| 27 | 27 |
bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";" |
| 28 | 28 |
"time" bin/postgres_vegbien pg_restore --exit-on-error --verbose --dbname=vegbien --schema="$schema" backups/vegbien.r12025.backup |
| 29 | 29 |
done |
Also available in: Unified diff
bugfix: config/VirtualBox_VMs/vegbiendev/README.TXT: pg_restore: don't restore analytical_db schema because we don't use it and it depends on public, which we're not restoring