Re: pg_dump exclude tables

"Mary Sipple" <msipple(at)iii(dot)com> writes:
> I'm using postgresql 8.2.3 and am trying to run pg_dump with some tables
> excluded. It seems that no matter what I try pg_dump core dumps on me --
> "Segmentation Fault (core dumped)". The -t flag works fine but -T does not.
> Even excluding just one table gives me the segmentation fault.

Hmm, I see no crash here ...

The most nearly related thing I see in the CVS logs is this:

2007-04-16 14:42 tgl

* src/bin/pg_dump/pg_dump.c (REL8_2_STABLE): Fix pg_dump to not
crash if -t or a similar switch is used to select a serial sequence
for dumping without also selecting its owning table. Make it not
try to emit ALTER SEQUENCE OWNED BY in this situation. Per report
from Michael Nolan.

but that doesn't quite seem to match your complaint.

8.2.3 is pretty old though. Please update to 8.2.current (8.2.13 is
latest) and see if you still see the problem. If so, please send a
complete test case to pgsql-bugs. There is probably something specific
about your database that is causing the failure, but I have no way to
guess what.

regards, tom lane