"Tim Penhey" <[EMAIL PROTECTED]> writes: > This has been a bit of a point of confusion for me. > > When do you use pg_restore vs. psql -f dumped.sql?
If you used the 'custom' or 'tar' formats of pg_dump, you need to use pg_restore. If you dumped as straight SQL (the default), just feed the dump to psql. -Doug ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
