* to use a database backup:

# {

make mk_db # restore users, which are not part of the backup

l=1 src='starscream.nceas.ucsb.edu:~/bien/' dest=. put backups/vegbien.r12025.backup # runtime: 35 min ("0:32:34")

for schema in temp util py_util geoscrub herbaria IRMNG IUCN NCBI newWorld TNRS ARIZ; do

	bin/psql_verbose_vegbien <<<"CREATE SCHEMA \"$schema\";"

	# must use for loop because pg_restore doesn't support multiple --schema

	# options (it just uses the last one)

	# (http://postgresql.1045698.n5.nabble.com/pg-restore-should-accept-multiple-t-switches-td2399138.html)

# ...

# }

* to use a clean database: