note to self: restoring a database

Tonight I was setting up a new FreshPorts node for development. It took me a while to remember the steps.

sudo su -l postgres
psql template1 < globals.sql
createdb  -T template0 -E SQL_ASCII freshports.org
psql freshports.org

create language plperl;
exit;
time pg_restore -j 32 -d freshports.org ~dan/dump/freshports.org.dump

This takes about 45 minutes.