database renaming, dumping and reloading

to dump production db:
from commandline: pg_dump -U postgres -h db5.sgn.cornell.edu cxgn_musabase | db5.cxgn_musabase.pgsql.gz

to rename old test db: 
ALTER DATABASE sandbox_musabase RENAME TO sandbox_musabase_backup
if there is an error, check for active processes:  SELECT * FROM pg_stat_activity;
and force disconnect of processes (should be idle!):
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid( ) AND datname = 'sandbox_musabase';
the run ALTER command again, or remove it:
DROP DATABASE sandbox_musabase;

to create new testdb and load productiondb dump:
CREATE DATABASE sandbox_musabase TEMPLATE template0;
then from commandline: gunzip -c db5.cxgn_musabase.pgsql.gz | psql -U postgres -h db4.sgn.cornell.edu sandbox_musabase