Error while running pg_dump

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.

regards, tom lane

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                                                      |
+-----------------------------------------------------------------+