Re: Backups and restores. - Mailing list pgsql-general

> 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