Re: Problems with pg_dump - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problems with pg_dump
Date
Msg-id 23709.1075157315@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with pg_dump  (Stefan Holzheu <stefan.holzheu@bitoek.uni-bayreuth.de>)
List pgsql-admin
Stefan Holzheu <stefan.holzheu@bitoek.uni-bayreuth.de> writes:
> Well, I never used a packet sniffer but if anyone tells me what to
> capture, I'd be glad to.

Since we don't know where exactly in the table the error occurs, I think
you'll just have to capture the whole connection traffic between pg_dump
and the backend.  You could help keep it to a reasonable size by doing a
selective dump of just one table, viz "pg_dump -t tablename dbname",
although I guess you might have to try a few times to reproduce the
error that way ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Yuji Shinozaki
Date:
Subject: Re: [Fwd: binary tree query]
Next
From: "Chris White (cjwhite)"
Date:
Subject: Error seen when vacuuming pg_largeobject table