Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5B08163373B;
	Tue, 23 Feb 2010 12:32:56 -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 79424-01; Tue, 23 Feb 2010 16:32:45 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 673F8633738;
	Tue, 23 Feb 2010 12:32:45 -0400 (AST)
Received: by wya21 with SMTP id 21so689293wya.19
	for <multiple recipients>; Tue, 23 Feb 2010 08:32:44 -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=apoqIOJ/YGSGlPY13whdc2QM5cfrViXlZ6h/Y5n27V8=;
	b=gB9aRa9nNIK7BuXM7ClAhSaV+upvZlqL+4R4+gJEIXMTV9+ZXBuKnAAZxKb6BSS1yA
	rJCHKV4m9S+m/esdYv8KaxXCwhVfuXdFiPEBgFwiL9TuMLmhkeO0ieCpC1wEiTC5G9gj
	vGM4Thn1HE+wvDzcZwHI0+RlV9jRHSR55YVI4=
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=DXLPR2Wi33laC/3oBDbK/r5Nc+nYtfN5/q/qPfJS7qoE3HED2odekEtRO+0bOTXfcr
	b/9QL4ofnrQZ8UZN40OKe/TglwTzUlbjwJe6wg1UmwIsh3USTaN33JHK35MFNwrjb6ph
	0vgxjFudUZ6wouBwv4jfppfJO3hsO+IgHRuY8=
MIME-Version: 1.0
Received: by 10.216.90.208 with SMTP id e58mr833862wef.57.1266942764158; Tue,
	23 Feb 2010 08:32:44 -0800 (PST)
In-Reply-To: <4B83E6CE.1060707@archonet.com>
References: <4B830D12020000250002F4C1@gw.wicourts.gov>
	<bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com>
	<4B83E6CE.1060707@archonet.com>
Date: Wed, 24 Feb 2010 00:32:43 +0800
Message-ID: <bd9689741002230832p296d2ee4i79db6f2b9fea74e3@mail.gmail.com>
Subject: Re: [GENERAL] Re: how do I do dump and restore without
	bugging with constraint?
From: "Net Tree Inc." <nettreeinc@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>, pgsql-admin@postgresql.org,
	pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary=0016e6db2ae76890b804804719ba
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/180
X-Sequence-Number: 33783

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

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

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

yeah that&#39;s what I means to do. <br><br>How do I use 8.4 pg_restore? th=
e 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, b=
ut I am not sure how to do the command. <br>
<br>Is this correct? pg_restore -h (my target machine IP) -U postgres -d (t=
arget db) mydb.dump<br><br>Steven<br><br><div class=3D"gmail_quote">On Tue,=
 Feb 23, 2010 at 10:31 PM, Richard Huxton <span dir=3D"ltr">&lt;<a href=3D"=
mailto:dev@archonet.com">dev@archonet.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class=3D"im"=
>On 23/02/10 09:17, Net Tree Inc. wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Why am I keep getting error with version issues.... I am trying to restore =
a<br>
backup file from a 8.4 postgresql server to a 8.3 postgresql server.<br>
</blockquote>
<br></div>
Well, an 8.4 dump isn&#39;t always going to be compatible with an 8.3 serve=
r, is it? If there weren&#39;t differences, the version number wouldn&#39;t=
 have changed.<div class=3D"im"><br>
<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
[postgres@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup<br>
pg_restore.bin: [archiver] unsupported version (1.11) in file header<br>
</blockquote>
<br></div>
Try using the 8.4 pg_restore (but keep the &quot;-i&quot; to tell it to ign=
ore the version checks). You may still see errors, but there is a good chan=
ce it will work.<br>
<br>
You&#39;re also restoring into the &quot;postgres&quot; database here - is =
that what you meant to do?<br><font color=3D"#888888">
<br>
-- <br>
 =A0Richard Huxton<br>
 =A0Archonet Ltd<br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>----------------=
-----------------------<br>Steven Huang<br>

--0016e6db2ae76890b804804719ba--