renewing postgres database from dump

My local copy of the SGH postgres database was out of date, so I picked up the dump from saiwaves

pg_dump sgh > /home/sgh/sghdbdump

Before loading onto my system, I had to remove the existing database with

dropdb sgh

then create it again with

createdb

and then run

psql -d sgh -f sghdbdump

Sirf kuch hi lamhon mein apka swadisht database tayyaar!