Re: Error while running pg_dump - Mailing list pgsql-general

From Ron Johnson
Subject Re: Error while running pg_dump
Date
Msg-id 1060205839.10161.9.camel@haggis
Whole thread Raw
In response to Re: Error while running pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 2003-08-06 at 15:54, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
> > $ pg_dump -Ft -v test1 | gzip > test1.pdmp.tar.gz
> > pg_dump: saving database definition
> > pg_dump: reading namespaces
> > pg_dump: reading user-defined types
> > [snip]
> > pg_dump: dumping contents of table t_lane_tx2
> > pg_dump: dumping contents of table t_lane_tx
> > pg_dump: [tar archiver] could not write to tar member (wrote 47,
> > attempted 317)
>
> > Has anyone seen this error before?
>
> Sounds like this:
> http://archives.postgresql.org/pgsql-bugs/2003-08/msg00025.php
>
> If you're not suffering from /tmp overflow, let us know.

I wouldn't be surprised.  The vacuumed sum of the data/base directory
is 15GB, and / is slightly less than 4GB.

So I should do this instead?
$ pg_dump -Fc -v test1 > test1.pdmp

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



pgsql-general by date:

Previous
From: Ross Murray
Date:
Subject: Broken pipe at PQconnectdb
Next
From: Tom Lane
Date:
Subject: Re: Broken pipe at PQconnectdb