From: | Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Michael Andreasen <michael(at)dunlops(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_restore problem |
Date: | 2006-05-31 10:38:36 |
Message-ID: | 447D722C.3050904@ATConsultancy.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)dunlops(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | raja chidambaram | 2006-05-31 10:46:08 | BUG #2460: bug on postgres crash recovery |
Previous Message | Henrik Zagerholm | 2006-05-31 06:43:59 | Re: reindexdb command utlility |