Postgres Pro
Downloads
Home   >   mailing lists

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 27262.1471557674@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] add option to pg_dumpall to exclude tables from the dump  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: [PATCH] add option to pg_dumpall to exclude tables from the dump  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view 
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> On 8/18/16 2:40 PM, Tom Lane wrote:
>> 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.

> I agree, but I think mandating a database name (which I suppose could be 
> *) with the specifiers would solve that issue.

Hmm, something like "-T dbname1:pattern1 -T dbname2:pattern2" ?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Curing plpgsql's memory leaks for statement-lifespan values
Next
From: Claudio Freire
Date:
Subject: Re: [WIP] [B-Tree] Keep indexes sorted by heap physical location