Thread: Error while running pg_dump
Hi, v7.3.3 $ 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? TIA -- +-----------------------------------------------------------------+ | 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 | +-----------------------------------------------------------------+
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 | +-----------------------------------------------------------------+