Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A052B9FA23F for ; Fri, 1 Dec 2006 15:32:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 67785-06 for ; Fri, 1 Dec 2006 15:32:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C20349F9F0E for ; Fri, 1 Dec 2006 15:32:46 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kB1JWjv3001694; Fri, 1 Dec 2006 14:32:45 -0500 (EST) To: Peter Wilson cc: pgsql-admin@postgresql.org Subject: Re: Problem restoring with pg_dump In-reply-to: References: <6113.1164728816@sss.pgh.pa.us> Comments: In-reply-to Peter Wilson message dated "Tue, 28 Nov 2006 23:31:24 +0000" Date: Fri, 01 Dec 2006 14:32:45 -0500 Message-ID: <1693.1165001565@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/11 X-Sequence-Number: 23803 Peter Wilson writes: > Tom Lane wrote: >> Could you show us the unmodified output from pg_restore -l, as well as >> the edits you made to produce the -L script? > Raw output from pg_restore -l is as follows: Hm, this shows only data entries. Was the original pg_dump made with -a, or did you use -a in the pg_restore -l command? If the latter, could we see the full -l output? I didn't have any luck trying to reproduce this behavior, so I'm supposing it depends on something you haven't shown us... regards, tom lane