Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 31CC1650285 for ; Wed, 27 Aug 2008 10:28:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59422-02-6 for ; Wed, 27 Aug 2008 10:28:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id 280D3650109 for ; Wed, 27 Aug 2008 10:27:55 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i31so1070123wxd.28 for ; Wed, 27 Aug 2008 06:27:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=BUtwig+gyPl9GlQ1C2bTy2GVHID3nLJwpBczjg2hXAE=; b=A3UmxMuS6OZJV8adxW4A/y435aJVxDcWTVC3TJrqWmR/h0oa8XK19pZJ/C1qhT1CRs U5p/q+A7LVS+zKIxc/Sla2zQbvJwty8EPEeau+jPluO5fhWcOylU5yehTreXrATZO7ib 1LVLgU0MdJjKq51pvdNkhiC1T4XnYS54HvTnQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=dGKzN4Fx2Ei1IpH/wJ7YtjDthyZJqolItKwij91LDEL1+ox1hCjedn4OKS31FBzc91 UWnT7lLyJCfvGXAe6B37eTYMCVFgP0oSS/7QnkRy/gtY9+dHAHI+vuUJ5FNKFoRjCLY2 JUIBa+RoipwWtXTRmPiUZVIKN6CENqTKYNHjU= Received: by 10.70.77.19 with SMTP id z19mr9332059wxa.83.1219843668302; Wed, 27 Aug 2008 06:27:48 -0700 (PDT) Received: by 10.70.71.12 with HTTP; Wed, 27 Aug 2008 06:27:48 -0700 (PDT) Message-ID: <3f0d61c40808270627ybbeb80ej2f8e1209b66c5f61@mail.gmail.com> Date: Wed, 27 Aug 2008 15:27:48 +0200 From: "Marco Bizzarri" To: Postgres Subject: Re: [GENERAL] Dumping/Restoring with constraints? In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/193 X-Sequence-Number: 30038 On Wed, Aug 27, 2008 at 3:19 PM, Phoenix Kiula wrote: > Hello. I have a database dump. With data and schema, which includes > all the constraints and rules. But it seems the pg_dumpall command > does not copy data in such a way that foreign keys are satisfied upon > restoring. Because tables are inter-related, importing them keep > giving errors and eventually no data is imported. Neither pg_dumpall > nor pg_restore seems to have a "without constraints" or "delay > constraints check" type command. What am I missing? Thanks for any > advice. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Isn't the --disable-triggers working for you? -- Marco Bizzarri http://iliveinpisa.blogspot.com/