Friday, March 09, 2007

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!

No comments:

Post a Comment