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

From Net Tree Inc.
Subject Re: [GENERAL] Re: how do I do dump and restore without bugging with constraint?
Date
Msg-id bd9689741002230832p296d2ee4i79db6f2b9fea74e3@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Re: how do I do dump and restore without bugging with constraint?  (Richard Huxton <dev@archonet.com>)
List pgsql-admin
yeah that's what I means to do.

How do I use 8.4 pg_restore? the DB server I am trying to restore is using 8.3. Do you mean do pg_restore on the same machine that I did pg_dump?? I am thinking of doing that too, but I am not sure how to do the command.

Is this correct? pg_restore -h (my target machine IP) -U postgres -d (target db) mydb.dump

Steven

On Tue, Feb 23, 2010 at 10:31 PM, Richard Huxton <dev@archonet.com> wrote:
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



--
---------------------------------------
Steven Huang

pgsql-admin by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [GENERAL] Re: how do I do dump and restore without bugging with constraint?
Next
From: "Net Tree Inc."
Date:
Subject: Re: how do I do dump and restore without bugging with constraint?