From: | "Nick Fankhauser - Doxpop" <nickf(at)doxpop(dot)com> |
---|---|
To: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Cc: | <xzilla(at)users(dot)sourceforge(dot)net> |
Subject: | Error message using pg_dump with tar format |
Date: | 2003-07-07 16:30:29 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGCEFPHLAA.nickf@doxpop.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi-
I'm getting the following error message:
pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted
166)
Here are the particulars:
-I'm running this command: "pg_dump -Ft prod | prod.dump.tar" (The database
is named prod)
-The dump gets about 1/4 of the way through, and then gives me the error
message and stops.
-I'm running PostgreSQL version 7.3.2.
-There is plenty of disk space available.
-The same command on the same database and server with same specs worked
last week when I was on V7.2.1.
-Since upgrading, more data has been added, but the structure of the
database is unchanged.
-Using the -v switch shows me that it always quits on the same table, but
otherwise adds no new information.
-The part of the error message in parentheses changes on each run. For
instance, on the last run, I got "(wrote 64, attempted 174)" The rest of
the message remains consistent.
-The table it quits on is fairly large- about 2.6GB. It is both "wide"
because it contains a text field that is usually a few sentences of text,
and "long", containing 9,137,808 records. This is also the only table in our
database that is split into multiple files.
-A text dump using this command works fine: "pg_dump prod > prod.dump.text"
I found a reference to this message in the admin list archives on 3/28/2003,
but it was in the context of a database containing large blobs (mine has no
blobs), and the suggestion was to upgrade to 7.3. I couldn't find a
resolution in that thread, so I'm not sure if it ever got worked out.
Any thoughts??
Thanks!
-Nick
---------------------------------------------------------------------
Nick Fankhauser
nickf(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2003-07-07 16:32:50 | Error message using pg_dump with tar format |
Previous Message | centeno | 2003-07-07 16:26:14 | Ask for Web hosting information ... |