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

create language plperl;
time pg_restore -j 32 -d ~dan/dump/
Website Pin Facebook Twitter Myspace Friendfeed Technorati Digg Google StumbleUpon Premium Responsive

Leave a Comment

Scroll to Top