By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Pg Dump error

P: n/a
Trying to dump data from my database using:

pg_dump -a -Ft -b mdc_oz > mdc.tar

And I keep receiving the following error:
pg_dump: [tar archiver] could not write to tar member (wrote 3, attempted
203)

Any idea what this could be? I've dump other database on the same server
without issue

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Patrick Hatcher" <PH******@macys.com> writes:
Trying to dump data from my database using:
pg_dump -a -Ft -b mdc_oz > mdc.tar And I keep receiving the following error:
pg_dump: [tar archiver] could not write to tar member (wrote 3, attempted
203)


IIRC, the -Ft mode requires dumping into temp files in /tmp --- have you
got enough free space in /tmp for your largest table?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

P: n/a

thanks. It turn out to be a problem with one of the tables. It had a date
value of 543525-01-01. Somehow the COPY command allowed this to come in as
a date, but pg_Dump using a tar dump spat out a bogus error message. It
wasn't until I did a normal pg_dump did I actually see that it was an error
with a specific table.

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-422-1610 office
HatcherPT - AIM

Tom Lane
<tg*@sss.pgh.pa.us>
To
11/21/2003 09:16 AM "Patrick Hatcher"
<PH******@macys.com>
cc
pg***********@postgresql.org
Subject
Re: [GENERAL] Pg Dump error




"Patrick Hatcher" <PH******@macys.com> writes:
Trying to dump data from my database using:
pg_dump -a -Ft -b mdc_oz > mdc.tar And I keep receiving the following error:
pg_dump: [tar archiver] could not write to tar member (wrote 3, attempted
203)


IIRC, the -Ft mode requires dumping into temp files in /tmp --- have you
got enough free space in /tmp for your largest table?

regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.