On 23/02/10 09:17, Net Tree Inc. wrote:
Why am I keep getting error with version issues.... I am trying to restore a backup file from a 8.4 postgresql server to a 8.3 postgresql server.
Well, an 8.4 dump isn't always going to be compatible with an 8.3 server, is it? If there weren't differences, the version number wouldn't have changed.
[postgres@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup pg_restore.bin: [archiver] unsupported version (1.11) in file header
Try using the 8.4 pg_restore (but keep the "-i" to tell it to ignore the version checks). You may still see errors, but there is a good chance it will work.
You're also restoring into the "postgres" database here - is that what you meant to do?
-- Richard Huxton Archonet Ltd -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
