X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 91BC3474E44 for ; Mon, 24 Mar 2003 05:52:20 -0500 (EST) Received: from main.fi.ru (main.fi.ru [195.208.122.1]) by postgresql.org (Postfix) with ESMTP id 4E045475ECE for ; Mon, 24 Mar 2003 05:52:18 -0500 (EST) Received: from vaio ([212.111.39.145]) by main.fi.ru (8.11.6/8.11.6) with SMTP id h2OAjLq08484 for ; Mon, 24 Mar 2003 13:45:21 +0300 Message-ID: <009f01c2f1f2$d76a1af0$0101010a@vaio> From: "Tatiana Motova" To: Subject: pg_dump problem Date: Mon, 24 Mar 2003 10:47:40 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0098_01C2F1F2.CA8A0DE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=1.1 required=5.0 tests=BAYES_30,HTML_40_50,RCVD_IN_NJABL,RCVD_IN_OSIRUSOFT_COM, RCVD_IN_RELAYS_ORDB_ORG,X_NJABL_OPEN_PROXY version=2.50 X-Spam-Level: * X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/386 X-Sequence-Number: 8026 This is a multi-part message in MIME format. ------=_NextPart_000_0098_01C2F1F2.CA8A0DE0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable 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 l= et say 10 files in it, pg_dump works perfectly, but when about 400Mb of fil= es are loaded into db, pg_dump fails with the following message: pg_dump -a -b -Ft -f bdata_030321.tar -v mydb=20 ... 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. ------=_NextPart_000_0098_01C2F1F2.CA8A0DE0 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable
Hi all,
 
i have a problem dumping the database cont= aining=20 blobs.
 
The database has pdf files stored in = one of=20 the tables and when there are let say 10 files in it, pg_dump works=20 perfectly, but when about 400Mb of files are loaded into db, pg_dump fails = with=20 the following message:
 
pg_dump -a -b -Ft -f bdata_030321.tar -v&n= bsp;mydb=20
...
pg_dump: [tar archiver] could not write to= tar=20 member (wrote 872, attempted 8191)
 
It's not a matter of available disk space,= there's=20 plenty of it.
I'm using PostgreSQL 7.2.2 on Red Hat= =20 8.0
 
Help, please!
 
T.
------=_NextPart_000_0098_01C2F1F2.CA8A0DE0--