Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id C88F36421B3;
	Tue, 23 Feb 2010 05:18:38 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 07028-01-7; Tue, 23 Feb 2010 09:18:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.155])
	by mail.postgresql.org (Postfix) with ESMTP id 2525864244C;
	Tue, 23 Feb 2010 05:17:31 -0400 (AST)
Received: by fg-out-1718.google.com with SMTP id e21so696562fga.1
	for <multiple recipients>; Tue, 23 Feb 2010 01:17:30 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=amPns4xO4cIjrU/SnRFjn8v6u4y7t3Ft58ZCbfJjLaQ=;
	b=HmauYveOEy+eRJVy6Z/i02++qmoM6bMGxFLkQjTBORt/5JsePHHUcQ0oHTzGG7CMQ4
	HEfd/jrMSUvkM7CuOkwkp5jGKCuOZgUE9DMrjIvo/oYHZYaPPob7l8OtYbvLNcNKLoWJ
	Q/5xkHnWoRJW49UlwpQbJFhH7758kZlh4B2OA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=lQ0SXJj7PN75voBQxXmFsQG6Vhc2/33UO2Ib4JlbKAvKLUUVHuvjw7NTW9anJO8M82
	7g0vY6dcZQUlWId1wQ/lBWk0ma8xFt544CBWmZR6iPLdgYqngGxRKlUJ8H9fKqJ8doW5
	WLoCNwCEhvxx1kaUE9mis9yMvfp2NBkIw/e/g=
MIME-Version: 1.0
Received: by 10.216.88.71 with SMTP id z49mr352485wee.90.1266916650468; Tue,
	23 Feb 2010 01:17:30 -0800 (PST)
In-Reply-To: <4B830D12020000250002F4C1@gw.wicourts.gov>
References: <4B830D12020000250002F4C1@gw.wicourts.gov>
Date: Tue, 23 Feb 2010 17:17:30 +0800
Message-ID: <bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
Subject: Re: how do I do dump and restore without bugging with
	constraint?
From: "Net Tree Inc." <nettreeinc@gmail.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary=0016e6dab0ece9463f0480410443
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201002/172
X-Sequence-Number: 33775

--0016e6dab0ece9463f0480410443
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e6dab0ece9463f0480410443
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Why am I keep getting error with version issues.... I am trying to res=
tore a backup file from a 8.4 postgresql server to a 8.3 postgresql server.=
=A0</div><div><br></div><div>[postgres@localhost ~]$ pg_restore -C -d postg=
res -i isamdb.backup</div>
<div>pg_restore.bin: [archiver] unsupported version (1.11) in file header</=
div><div><br></div><br><div class=3D"gmail_quote">On Tue, Feb 23, 2010 at 1=
:02 PM, Kevin Grittner <span dir=3D"ltr">&lt;<a href=3D"mailto:Kevin.Grittn=
er@wicourts.gov">Kevin.Grittner@wicourts.gov</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;"><div class=3D"im">&quot;Net Tree Inc.&quot;=
 =A0wrote:<br>
<br>
&gt; When I do restore it shown alot errors related with constraints.<br>
&gt; How can I dump and to restore from old to new without dealing with<br>
&gt; constraint and just forces data dump to where it suppose to belong?<br=
>
<br>
</div>What version are you dumping from and to? =A0Exactly what errors are<=
br>
you getting? =A0(Copy and paste samples, please.)<br>
<br>
You might want to review this page:<br>
<br>
<a href=3D"http://wiki.postgresql.org/wiki/Guide_to_reporting_problems" tar=
get=3D"_blank">http://wiki.postgresql.org/wiki/Guide_to_reporting_problems<=
/a><br>
<font color=3D"#888888"><br>
-Kevin<br>
<br>
<br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>----------------=
-----------------------<br>Steven Huang<br>

--0016e6dab0ece9463f0480410443--