Thread: pg_restore problem

Hi,

from 7.3 I created a backup by:

pg_dumpall > backup

from 7.4 trying: pg_restore backup

results in postgres' [Archiver]s suspicion that "backup"
was not a valid archive.

Where to look?

TIA Erwin

mail@ekaiser.de wrote:
> pg_dumpall > backup
> from 7.4 trying: pg_restore backup
> results in postgres' [Archiver]s suspicion that "backup"
> was not a valid archive.

What you backup by pg_dumpall is to be restored using psql, not
pg_restore.  Read the man pages of pg_dump and pg_dumpall to confirm
what is to be used to restore the various forms of backups.