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 <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to