Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 45BEA9FBC92 for ; Tue, 19 Jun 2007 13:53:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 95927-10 for ; Tue, 19 Jun 2007 13:53:38 -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 374489FBB9D for ; Tue, 19 Jun 2007 13:53:38 -0300 (ADT) Received: from localhost (silene.metacarta.com [65.77.47.18]) by silene.metacarta.com (Postfix) with ESMTP id CE80714C8AA8; Tue, 19 Jun 2007 12:53:36 -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 26744-02; Tue, 19 Jun 2007 12:53:35 -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 0752614C8A82; Tue, 19 Jun 2007 12:53:35 -0400 (EDT) Message-ID: <46780A0E.9000705@metacarta.com> Date: Tue, 19 Jun 2007 12:53:34 -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> <4678096D.4030504@metacarta.com> In-Reply-To: <4678096D.4030504@metacarta.com> 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/182 X-Sequence-Number: 25850 Karl Wright wrote: > 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 > Nevermind. The man page was not clear for -l. Here's the output: kwright@baetis:/common$ sudo pg_restore -l dbsnapshot ; ; Archive created at Tue Jun 19 09:39:30 2007 ; dbname: metacarta ; TOC Entries: 20 ; Compression: 0 ; Dump Version: 1.7-0 ; Format: TAR ; Integer: 4 bytes ; Offset: 8 bytes ; ; ; Selected TOC Entries: ; 2; 0 17143 TABLE DATA public agents metacarta 3; 0 17147 TABLE DATA public ingeststatus metacarta 4; 0 17156 TABLE DATA public authconnectors metacarta 5; 0 17161 TABLE DATA public authconnections metacarta 6; 0 17175 TABLE DATA public connectors metacarta 7; 0 17180 TABLE DATA public repoconnections metacarta 8; 0 17198 TABLE DATA public jobs metacarta 9; 0 17210 TABLE DATA public schedules metacarta 10; 0 17220 TABLE DATA public jobcollections metacarta 11; 0 17227 TABLE DATA public jobqueue metacarta 12; 0 30176 TABLE DATA public repohistory metacarta 13; 0 30191 TABLE DATA public throttlespec metacarta 14; 0 30198 TABLE DATA public jobhopfilters metacarta 15; 0 30212 TABLE DATA public hopcount metacarta 16; 0 30226 TABLE DATA public intrinsiclink metacarta 17; 0 30239 TABLE DATA public hopdeletedeps metacarta 18; 0 30257 TABLE DATA public robotsdata metacarta 19; 0 30264 TABLE DATA public dnsdata metacarta 20; 0 0 BLOBS - BLOBS kwright@baetis:/common$ > > >