Thread: BUG #6655: restore backup

The following bug has been logged on the website:

Bug reference:      6655
Logged by:          Gloria Valladares
Email address:      gloria_evelis@hotmail.com
PostgreSQL version: 8.4.0
Operating system:   Ubuntu
Description:=20=20=20=20=20=20=20=20

/usr/bin/pg_restore --host localhost --port 5432 --username postgres
--dbname "Mantenimiento" --verbose
"/media/GVALLADARES/20120521_backup.backup"
pg_restore: [archivador] versi=C3=B3n no permitida (1.12) en el encabezado =
del
archivo

gloria_evelis@hotmail.com writes:
> PostgreSQL version: 8.4.0

> /usr/bin/pg_restore --host localhost --port 5432 --username postgres
> --dbname "Mantenimiento" --verbose
> "/media/GVALLADARES/20120521_backup.backup"
> pg_restore: [archivador] versión no permitida (1.12) en el encabezado del
> archivo

Archive version 1.12 means that the file was emitted by a 9.0 or later
version of pg_dump.  So you'll need a 9.0 or later version of pg_restore
to read it.  Depending on what server version it was dumped from, you
might have some problems restoring the objects in the dump into an 8.4
server, too.

BTW, if you really are running 8.4.0, you would be well advised to
update to a newer minor release.  The 8.4 release series is currently at
8.4.11, meaning you're missing 11 minor versions worth of bug fixes,
some of which were pretty critical.

            regards, tom lane