Re: [PATCH] add option to pg_dumpall to exclude tables from the dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] add option to pg_dumpall to exclude tables from the dump
Date
Msg-id 21499.1471549211@sss.pgh.pa.us
Whole thread Raw
In response to [PATCH] add option to pg_dumpall to exclude tables from the dump  (Juergen Hannappel <juergen@juergen-hannappel.de>)
Responses Re: [PATCH] add option to pg_dumpall to exclude tables from the dump  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Juergen Hannappel <juergen@juergen-hannappel.de> writes:
> A new option -T --exlude-table for pg_dumpall. This option is then
> passed through to the pg_dump which really does the work.
> This feature can be used to exclude large tables that are known not
> to change from a database backup dump so that only the changing parts
> of the database are dumped.

This seems pretty dubious to me, in particular that the identical -T
option will be passed willy-nilly into the pg_dump runs for every
database.  That seems more likely to be a foot-gun than something useful.

Also, if we believe that this has a safe use-case, why only -T, and
not pg_dump's other object selectivity options?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Fix deletion of speculatively inserted TOAST on conflict
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: WIP: About CMake v2