The Toolkit for Online Communities
18814 Community Members, 0 members online, 1850 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : pg_dump and pg_restoring from production to dev : One Message

Forum OpenACS Q&A: Re: pg_dump and pg_restoring from production to dev

Posted by Stan Kaufman on
Jade, does that work? It usually isn't subtle; either it does or it doesn't.

For what it's worth, this is what I do:

Edit all the \connect statements out of the dump file. I don't fundamentally understand what purpose they serve, but depending on how you set your permissions, they can result in only partial recreation of the db. And it will fail silently without showing in the error log.

Use this syntax -- see http://www.postgresql.org/docs/view.php?version=7.2&idoc=1&file=backup.html#BACKUP-DUMP-RESTORE

psql safe4all-dev < safe4all.dmp 2> errors.txt

This works fine for me anyway.