Re: pg_restore problem - Mailing list pgsql-bugs

From Harco de Hilster
Subject Re: pg_restore problem
Date
Msg-id 447D722C.3050904@ATConsultancy.nl
Whole thread Raw
In response to Re: pg_restore problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I had similar problems with the tar format. 3 smaller databases worked,
the biggest did not. Switching to -Fc fixed it for me.

Sorry for not reporting this.

Harco

Tom Lane wrote:
> Michael Andreasen <michael@dunlops.com> writes:
>
>> pg_dump -Ft $db | bzip2 > $db.dump.tbz
>> ...
>> pg_restore: [tar archiver] could not find header for file 3765.dat in
>> tar archive
>>
>
> Does it work better if you use -Fc format?  There was a similar report
> recently, which makes me think the tar-format code has got some kind
> of problem, but without a test case it's hard to look into it.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>

pgsql-bugs by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: reindexdb command utlility
Next
From: Henrik Zagerholm
Date:
Subject: Re: reindexdb command utlility