pg_restore problem

[mail@ekaiser.de]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Peter Eisentraut]

Re: pg_restore problem

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

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.



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Peter Eisentraut]

Re: pg_restore problem

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

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.



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings