Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6B93Na54869 for ; Wed, 11 Jul 2001 05:03:23 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 2.12 #1) id 15KFtv-000FoD-0U; Wed, 11 Jul 2001 10:03:20 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 155EB11EE2; Wed, 11 Jul 2001 09:57:52 +0100 (BST) Message-ID: <00bc01c109e7$904f5c60$1001a8c0@archonet.com> From: "Richard Huxton" To: "Josh Berkus" , References: Subject: Re: Problems with PG_DUMP and restore Date: Wed, 11 Jul 2001 09:47:33 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/138 X-Sequence-Number: 3930 From: "Josh Berkus" > Richard, > > Try having a look at the order the tables get inserted esp. with > > regard to > > any foreign keys etc. - I'm not sure pgdump is that clever about such > > things. > > Thanks. I did try that; however: > 1. Even trying re-loading the tables twice did not work, as it should > have with missing foriegn keys. > 2. I did not see any Unmatched Reference errors in the log, as I > typically do with missing keys. > > Further, I *was* able to re-load the database from a unitary pg_dump > file ... one that includes both DDL and data. It's just when I split > the pg_dump into two files -- one for DDL, one for data -- that it > fails. > > BTW, I'm using 7.1RC2 Was there not some fix to pgdump in 7.1.1? Yep - pg_dump fixes (Philip) pg_dump can dump 7.0 databases (Philip) Might be worth a quick upgrade & see what happens. Failing that, it isn't something to do with permissions and pgdump connecting as various users? - Richard Huxton