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.