pg_dump problem

From: "Tatiana Motova" <t(dot)motova(at)inform-link(dot)co(dot)uk>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump problem
Date: 2003-03-21 18:15:20
Message-ID: 004101c2efd5$e2131890$0101010a@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Help, please!

T.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-03-21 18:24:38 Re: indexes not being used!
Previous Message Joe Conway 2003-03-21 18:12:46 Re: indexes not being used!