pg_dump exclude tables

From: "Mary Sipple" <msipple(at)iii(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump exclude tables
Date: 2009-06-19 15:24:13
Message-ID: 004d01c9f0f2$078b4790$16a1d6b0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message torrez 2009-06-19 15:43:28 WAL archiving and backup TAR
Previous Message Scott Marlowe 2009-06-19 14:49:19 Re: order by question