Tadek’s Blog

Dumping the database: pg_dump mssd -F c -f file.dumppsql -U mssd -h 127.0.0.1 -O -x

And restoring it: pg_restore -d mssd file.dumppsql -U mssd -h 127.0.0.1 -O -x -O – do not change the ownership -x – do not restore ACLs

This entry was posted on Friday, August 19th, 2005 at 3:46 pm and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.