Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 232B66328BD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 23 Feb 2010 02:40:22 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 43216-03-5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 23 Feb 2010 06:40:09 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25])
	by mail.postgresql.org (Postfix) with ESMTP id E6EC16325B0
	for <pgsql-admin@postgresql.org>; Tue, 23 Feb 2010 02:39:46 -0400 (AST)
Received: by ey-out-2122.google.com with SMTP id 25so647717eya.33
	for <pgsql-admin@postgresql.org>; Mon, 22 Feb 2010 22:39:45 -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=ExlEsXXcGfg5cQclE904ABC4ooksRGNixjl4MWA5HL8=;
	b=IquIh8maMe67diEXtFEYfIZWRKcYAs0QNNqrUcFdiKThIFuwZaxWVKuIc0WMQsNtxN
	z3OgdvsNVcd1hmDpMUtVuMZXQnlOuFzWMb8fXvQbmYJZ6c2/SsyHgIVjkaF4Hp9T8dJX
	yuUDRTlV2vhHzHOvnyy+G+j8CTpl6Lz3XkMWw=
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=lD5lQPY2XPDMAj096JIr2LLy15Jdt8/vuJgGS/q1sQSYZZjskhxqkLGzfhR/pmOuJ6
	hW3o6GkyovxVr7qJ+IIRuEHNXg4KV6XtH4pqMfyS31uxv5cmACmmolgB0z4VNm7NfU6a
	l7SOkmT5Y3pT8utfKh+jhAW/JLKrx6BFPuKHI=
MIME-Version: 1.0
Received: by 10.216.93.79 with SMTP id k57mr6830597wef.161.1266907184210;
 Mon,
	22 Feb 2010 22:39:44 -0800 (PST)
In-Reply-To: <4B830D12020000250002F4C1@gw.wicourts.gov>
References: <4B830D12020000250002F4C1@gw.wicourts.gov>
Date: Tue, 23 Feb 2010 14:39:44 +0800
Message-ID: <bd9689741002222239rfe6033fhe07511da59aa3d5f@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
Content-Type: multipart/alternative; boundary=0016e6d64544ada55c04803ed0fa
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/171
X-Sequence-Number: 33774

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

Ok, I am just trying to find the proper way to back and restore database
that contain restriction.

The other way to ask. If I have two 99% schema similar databases. The old
one might contain few columns that does not exist in the new one and contain
constrains that the new DB does not have. In that case, what's standard to
do this?

Since they are 99% similar in schema, can I do "data dump" only ? will that
work?

If owner for database between Old and new DB are different, do I must add
that owner in by create new role?

appreciated,

Steven

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

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

<span class=3D"Apple-style-span" style=3D"font-family: arial, sans-serif; f=
ont-size: 13px; border-collapse: collapse; ">Ok, I am just trying to find t=
he proper way to back and restore database that contain restriction.=A0<div=
><br>
</div><div>The other way to ask. If I have two 99% schema=A0similar databas=
es. The old one might contain few columns that does not exist in the new on=
e and contain constrains that the new DB does not have. In that case, what&=
#39;s standard to do this?=A0</div>
<div><br></div><div>Since they are 99% similar in schema, can I do &quot;da=
ta dump&quot; only ? will that work?=A0</div><div><br></div><div>If owner f=
or database between Old and new DB are different, do I must add that owner =
in by create new role?</div>
<div><br></div><div>appreciated,</div><div><br></div><div>Steven</div></spa=
n><br><div class=3D"gmail_quote">On Tue, Feb 23, 2010 at 1:02 PM, Kevin Gri=
ttner <span dir=3D"ltr">&lt;<a href=3D"mailto:Kevin.Grittner@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>

--0016e6d64544ada55c04803ed0fa--