BUG #6655: restore backup

Lists: pgsql-bugs
From: gloria_evelis(at)hotmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6655: restore backup
Date: 2012-05-21 17:50:24
Message-ID: E1SWWkS-0000Uh-53@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6655
Logged by: Gloria Valladares
Email address: gloria_evelis(at)hotmail(dot)com
PostgreSQL version: 8.4.0
Operating system: Ubuntu
Description:

/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


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gloria_evelis(at)hotmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6655: restore backup
Date: 2012-05-21 23:18:48
Message-ID: 9427.1337642328@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

gloria_evelis(at)hotmail(dot)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] versin 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