Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8F206632D6B for ; Tue, 23 Feb 2010 01:10:23 -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 55302-05 for ; Tue, 23 Feb 2010 05:10:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hogranch.com (hogranch.com [75.101.82.47]) by mail.postgresql.org (Postfix) with ESMTP id BE49C632D41 for ; Tue, 23 Feb 2010 01:10:10 -0400 (AST) Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id o1N5A1L07323; Mon, 22 Feb 2010 21:10:01 -0800 Message-ID: <4B836324.7090604@hogranch.com> Date: Mon, 22 Feb 2010 21:09:56 -0800 From: John R Pierce User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: "Net Tree Inc." CC: pgsql-general@postgresql.org Subject: Re: how do I do dump and restore without bugging with constraint? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/955 X-Sequence-Number: 159731 Net Tree Inc. wrote: > Hi all, > > I am dumping both schema and data from old database to new one. The > new database schema is somehow contain slightly different schema then > the old one. 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? > > > > if you're dumping the schema and the data, you should be restoring into an empty database, not into an existing database.