Thread: pg_dump problem

pg_dump problem

From
"Tatiana Motova"
Date:
Hi all,
 
i have a problem dumping the database containing blobs.
 
The database has pdf files stored in one of the tables and when there are let say 10 files in it, pg_dump works perfectly, but when about 400Mb of files are loaded into db, pg_dump fails with the following message:
 
pg_dump -a -b -Ft -f bdata_030321.tar -v mydb
...
pg_dump: [tar archiver] could not write to tar member (wrote 872, attempted 8191)
 
It's not a matter of available disk space, there's plenty of it.
I'm using PostgreSQL 7.2.2 on Red Hat 8.0
 
Help, please!
 
T.