Re: Re: [ADMIN] how do I do dump and restore without bugging with constraint? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Re: [ADMIN] how do I do dump and restore without bugging with constraint?
Date
Msg-id 4B83E6CE.1060707@archonet.com
Whole thread Raw
In response to Re: [ADMIN] how do I do dump and restore without bugging with constraint?  ("Net Tree Inc." <nettreeinc@gmail.com>)
Responses Re: Re: [ADMIN] how do I do dump and restore without bugging with constraint?  ("Net Tree Inc." <nettreeinc@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Subqueries or Joins? Problems with multiple table query
Next
From: "A. Kretschmer"
Date:
Subject: Re: Subqueries or Joins? Problems with multiple table query