> Brian Avis 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
>
>> pg_restore: [archiver] input file does not appear to be a valid
>> archive
>
> These archives are supposed to be restored using psql. The pg_dump
> reference page should tell you the details.
>
Gee, the man page of pg_restore says:
DESCRIPTION
pg_restore is a utility for restoring a PostgreSQL
database from an archive created by pg_dump(1) in one of
the NON-PLAIN-TEXT (emphasis added) formats.
;)
~Berend Tober