Re: pg_dump problem - Mailing list pgsql-admin

From Robert Treat
Subject Re: pg_dump problem
Date
Msg-id 1048533104.13853.309.camel@camel
Whole thread Raw
In response to pg_dump problem  ("Tatiana Motova" <t.motova@inform-link.co.uk>)
List pgsql-admin
On Fri, 2003-03-21 at 13:15, Tatiana Motova wrote:
> 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.
>

Haven't seen any other response on this one.... This bug used to exist
in the 7.1.x versions, but I think it was fixed in one of the 7.2.x
releases. Can you post your version info? In the meantime you might be
able to work around it by using the -Fc instead.

Robert Treat


pgsql-admin by date:

Previous
From: Jodi Kanter
Date:
Subject: alter table
Next
From: Robert Treat
Date:
Subject: Re: PROBLEM WITH pg_hba.conf in POSTGRES 7.3.2