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
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
I have a problem restoring our large database. This has only stared
happening since we moved to 8.1.x
We are currently on 8.1.3.
We perform an over night dump of the database as follows;
pg_dump -Ft $db | bzip2 > $db.dump.tbz
This happens fine, without any errors.
On our backup machine also
