Re: Error while running pg_dump

On Wed, 2003-08-06 at 15:54, Tom Lane wrote:
> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+