From: Ian Lea <ian.lea@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: how do I do dump and restore without bugging with constraint?
Date: Tue, 23 Feb 2010 09:35:51 +0000
Message-ID: <8c4e68611002230135x22f9f855ocd777d9d9545d594@mail.gmail.com> (raw)
In-Reply-To: <bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
References: <4B830D12020000250002F4C1@gw.wicourts.gov>
<bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
It is unreasonable to expect 8.3 programs to be able to understand
everything that 8.4 programs might write.
What format is your dump in? Plain text (--format=p) might work. Or
try dumping the 8.4 database with the 8.3 version of pg_dump, or maybe
use the 8.4 pg_restore against the 8.3 database.
--
Ian.
On Tue, Feb 23, 2010 at 9:17 AM, Net Tree Inc. <nettreeinc@gmail.com> 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.
> [postgres@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup
> pg_restore.bin: [archiver] unsupported version (1.11) in file header
>
> On Tue, Feb 23, 2010 at 1:02 PM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>>
>> "Net Tree Inc." wrote:
>>
>> > When I do restore it shown alot errors related with constraints.
>> > How can I dump and to restore from old to new without dealing with
>> > constraint and just forces data dump to where it suppose to belong?
>>
>> What version are you dumping from and to? Exactly what errors are
>> you getting? (Copy and paste samples, please.)
>>
>> You might want to review this page:
>>
>> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>>
>> -Kevin
>>
>>
>
>
>
> --
> ---------------------------------------
> Steven Huang
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ian.lea@gmail.com
Subject: Re: how do I do dump and restore without bugging with constraint?
In-Reply-To: <8c4e68611002230135x22f9f855ocd777d9d9545d594@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox