On 09/21/2012 01:01 AM, Kasia Tuszynska wrote:
Hi Everybody,
I am experimenting with backups and restores….
I am running into something curious and would appreciate any suggestions.
Backing up from:
Postgres 8.3.0
Windows 2003 sp1 server (32bit)
-Took a compressed binary backup of a single db (the default option in
pgAdminIII, right click backup)
-Took a plane backup of the same single db, (plane option in the right
click backup gui in pgAdminIII)
Did you back up using the old version of PgAdmin-III with the old
pg_dump? If so, problems restoring into PostgreSQL 9.1 are likely.
If possible, dump the old database using the *new* pg_dump. If you're
using the PgAdmin-III GUI, connecting to the old DB from the new PgAdmin
on the new computer should do the trick.
--
Craig Ringer
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
