Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB2C66502A9 for ; Wed, 27 Aug 2008 10:21:30 -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 51616-04-2 for ; Wed, 27 Aug 2008 10:20:56 -0300 (ADT) 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.27]) by postgresql.org (Postfix) with ESMTP id EC9C364FD24 for ; Wed, 27 Aug 2008 10:19:28 -0300 (ADT) Received: by ey-out-2122.google.com with SMTP id 6so446796eyi.61 for ; Wed, 27 Aug 2008 06:19:24 -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:mime-version:content-type:content-transfer-encoding :content-disposition; bh=rlQqPqcR84jlBr5LOIWXUdR46YMSs9qVnM7D5WkiNXE=; b=NOogvZl9cwKV0vXmPYLtY/PqZ13aymSbNP8IK2OHaDLIhy1WHmoNaA2OiVd67aJeMv CuigcMLmRRdZLnzEQE899swlcBxbCG6eq0Bub+sVuPTj4TQquR3nJFGrmh8L8fDPPlsR DaEmMBAAiGEs+lIdRu1BDpooWNu8x5v6mEwRI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=AvVcCherFnkIPF+IznIKd7Vv3A7uZHAq3gyJCFqugQnw+7ntBBQ6r52E18LsvswEMd sy4DIHC95R9HsGDT16h64jPF/v6ihTYCkAa2A7yMydHmyR8Rsu9eWA2/4q2vXQvZC+tG CLnWOKy5m7Rl0jDnc4C5EwCgX7HID9j/7WnNQ= Received: by 10.210.105.20 with SMTP id d20mr10218298ebc.91.1219843164870; Wed, 27 Aug 2008 06:19:24 -0700 (PDT) Received: by 10.210.130.1 with HTTP; Wed, 27 Aug 2008 06:19:24 -0700 (PDT) Message-ID: Date: Wed, 27 Aug 2008 21:19:24 +0800 From: "Phoenix Kiula" To: "PG-General Mailing List" Subject: Dumping/Restoring with constraints? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/937 X-Sequence-Number: 136767 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.