Skip site navigation (1) Skip section navigation (2)

Re: Export/import issue/question

From: Karl Wright <kwright(at)metacarta(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Export/import issue/question
Date: 2007-06-19 16:50:53
Message-ID: 4678096D.4030504@metacarta.com (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:
> Karl Wright <kwright(at)metacarta(dot)com> 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




In response to

Responses

pgsql-admin by date

Next:From: Karl WrightDate: 2007-06-19 16:53:34
Subject: Re: Export/import issue/question
Previous:From: Joshua D. DrakeDate: 2007-06-19 16:50:29
Subject: Re: [PERFORM] Postgres VS Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group