Thread: pg_dump exclude tables

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.

This works fine:

        pg_dump -Upostgres -h<socket> -p<port> -t "<table name>" <database>

but this core dumps:

        pg_dump -Upostgres -h<socket> -p<port> -T "<table name>" <database>

Have you successfully run PostgreSQL 8.2 (or thereabouts) pg_dump that excludes tables? Could you share how you do this? Is this a bug in version 8.2.3?

Thanks,  Mary

"Mary Sipple" <msipple@iii.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