pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tatiana Motova <t.motova@inform-link.co.uk>
To: pgsql-admin@postgresql.org
Subject: pg_dump problem
Date: Mon, 24 Mar 2003 10:47:40 -0000
Message-ID: <009f01c2f1f2$d76a1af0$0101010a@vaio> (raw)

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.

view thread (18+ messages)  latest in thread

Message-ID: <009f01c2f1f2$d76a1af0$0101010a@vaio>
Permalink:  ../009f01c2f1f2$d76a1af0$0101010a@vaio/
Also on:    postgresql.org/message-id/009f01c2f1f2$d76a1af0$0101010a@vaio

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: t.motova@inform-link.co.uk
  Subject: Re: pg_dump problem
  In-Reply-To: <009f01c2f1f2$d76a1af0$0101010a@vaio>
  References: <009f01c2f1f2$d76a1af0$0101010a@vaio>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox