Message-ID: <4B83E6CE.1060707@archonet.com>
Date: Tue, 23 Feb 2010 14:31:42 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.9pre) Gecko/20100213 Lightning/1.0b1 Shredder/3.0.2pre
MIME-Version: 1.0
To: "Net Tree Inc." <nettreeinc@gmail.com>
CC: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	pgsql-admin@postgresql.org, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Re: how do I do dump and restore without bugging
	with 	constraint?
References: <4B830D12020000250002F4C1@gw.wicourts.gov>
	<bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
In-Reply-To: <bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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