From: | "Net Tree Inc(dot)" <nettreeinc(at)gmail(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Re: how do I do dump and restore without bugging with constraint? |
Date: | 2010-02-23 16:32:43 |
Message-ID: | bd9689741002230832p296d2ee4i79db6f2b9fea74e3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(at)archonet(dot)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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Net Tree Inc. | 2010-02-23 16:36:10 | Re: how do I do dump and restore without bugging with constraint? |
Previous Message | Richard Huxton | 2010-02-23 14:31:42 | Re: [GENERAL] Re: how do I do dump and restore without bugging with constraint? |
From | Date | Subject | |
---|---|---|---|
Next Message | Net Tree Inc. | 2010-02-23 16:36:10 | Re: how do I do dump and restore without bugging with constraint? |
Previous Message | Ben Chobot | 2010-02-23 16:23:51 | Re: tuning bgwriter in 8.4.2 |