Re: excluding tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: excluding tables
Date
Msg-id 11940.1219938618@sss.pgh.pa.us
Whole thread Raw
In response to excluding tables  (Rick <ellis@blameitonlove.com>)
List pgsql-admin
Rick <ellis@blameitonlove.com> writes:
> Is there a way to get pg_dumpall to exclude a table or
> do I have to dump the tables indivually with pg_dump?

No, pg_dumpall doesn't have any provision for passing different
switches for different databases to its invocations of pg_dump.

Recommended practice here would be to combine pg_dumpall -g
with the results of manual per-database invocations of pg_dump.

            regards, tom lane

pgsql-admin by date:

Previous
From: windsurferdrew-pg@yahoo.com
Date:
Subject: Re: WAL files during a backup
Next
From: Carol Walter
Date:
Subject: privileges