Brian Avis <brian(dot)avis(at)searhc(dot)org> writes:
> I am upgrading my workstation to 7.3.3. I have some database backups
> that were created with this command.
>
> /usr/local/pgsql/bin/pg_dump $db | gzip > /usr/local/pgsql/backups/$filename
>
> Which generates this sort of file.
>
> pgdump_2003-6-5-csp.gz
For dumps in SQL format (the default), feed them to 'psql' rather than
using 'pg_restore', which is for "tar" and "custom" format dumps.
-Doug