(Work in Progress)
# from https://gist.github.com/brock/63830f11c0945f82f9ea curl -o pg_extract.sh https://gist.githubusercontent.com/brock/63830f11c0945f82f9ea/raw/ff164b14311de62ee475d1612f1e80e4df6edc15/pg_extract.sh chmod 755 pg_extract.sh # get the database scp isda:/home/shared/clowder/seagrant-dev/postgresql/dumpall.sql.gz seagrant-dev.sql.gz gunzip seagrant-dev.sql.gz # split the database (takes a while) ./pg_extract.sh seagrant-dev.sql # should see names of databases: # Evaluating geostream... # load database createdb seagrantdev -O clowder psql -d seagrantdev < seagrant-dev.sql |