Re: pg_restore problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_restore problem
Date
Msg-id 19059.1148958073@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore problem  (Michael Andreasen <michael@dunlops.com>)
Responses Re: pg_restore problem  (Harco de Hilster <Harco.de.Hilster@ATConsultancy.nl>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: kah_hang_ang@toray.com.my
Date:
Subject: statement stuck when the connection grew up to 45 or more
Next
From: Andreas Heiduk
Date:
Subject: Too many function calls in view with LEFT JOIN