"Tim Penhey" <tim@penhey.net> 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