Re: [BUGS] pg_restore problem

2006-05-31 Thread Harco de Hilster
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 arch

Re: [BUGS] pg_restore problem

2006-05-29 Thread Tom Lane
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 c