Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C824C9FB45A for ; Tue, 19 Jun 2007 13:51:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 26757-09 for ; Tue, 19 Jun 2007 13:50:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from silene.metacarta.com (silene.metacarta.com [65.77.47.18]) by postgresql.org (Postfix) with ESMTP id DAE7F9FA4AE for ; Tue, 19 Jun 2007 13:50:59 -0300 (ADT) Received: from localhost (silene.metacarta.com [65.77.47.18]) by silene.metacarta.com (Postfix) with ESMTP id 2D29914C8AAC; Tue, 19 Jun 2007 12:50:56 -0400 (EDT) Received: from silene.metacarta.com ([65.77.47.18]) by localhost (silene.metacarta.com [65.77.47.18]) (amavisd-new, port 10024) with ESMTP id 26457-03; Tue, 19 Jun 2007 12:50:54 -0400 (EDT) X-Auth-Received: from [65.77.47.195] (dhcp-65-77-47-195.metacarta.com [65.77.47.195]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by silene.metacarta.com (Postfix) with ESMTP id 8813614C8AA7; Tue, 19 Jun 2007 12:50:54 -0400 (EDT) Message-ID: <4678096D.4030504@metacarta.com> Date: Tue, 19 Jun 2007 12:50:53 -0400 From: Karl Wright User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Export/import issue/question References: <4677F3D2.6050909@metacarta.com> <29984.1182268843@sss.pgh.pa.us> In-Reply-To: <29984.1182268843@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at metacarta.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/181 X-Sequence-Number: 25849 Tom Lane wrote: > Karl Wright writes: >> But, I get the following error: >> pg_restore: [tar archiver] could not find header for file toc.dat in tar >> archive > > Could we see "pg_restore -l" output for that dump file? > > This looks a bit like some bugs we've seen before, eg, > http://archives.postgresql.org/pgsql-bugs/2006-10/msg00263.php > but the particular cause of that one wouldn't apply to a 7.4 > dump file. > > regards, tom lane > You could, if I could get it. When I do this: pg_restore -l it just hangs. No CPU usage, no disk usage - just sits there. When I do this: pg_restore -l --file dbsnapshot ... same thing. When I supply database credentials via -U and -W, then it simply displays: pg_restore: [tar archiver] could not find header for file toc.dat in tar archive Not very helpful, I know. Any other ideas? Karl