Re: pg_dump additional options for performance - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: pg_dump additional options for performance
Date
Msg-id 4884A90C.1030003@dunslane.net
Whole thread Raw
In response to Re: pg_dump additional options for performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump additional options for performance
List pgsql-patches

Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
>
>> I also suggested having three options
>> --want-pre-schema
>> --want-data
>> --want-post-schema
>> so we could ask for any or all parts in the one dump. --data-only and
>> --schema-only are negative options so don't allow this.
>> (I don't like those names either, just thinking about capabilities)
>>
>
> Maybe invert the logic?
>
>     --omit-pre-data
>     --omit-data
>     --omit-post-data
>
> Not wedded to these either, just tossing out an idea...
>
>
>

Please, no. Negative logic seems likely to cause endless confusion.

I'd even be happier with --schema-part-1 and --schema-part-2 if we can't
find some more expressive way of designating them.

cheers

andrew

pgsql-patches by date:

Previous
From: Tatsuo Ishii
Date:
Subject: WITH RECUSIVE patches 0721
Next
From: Alvaro Herrera
Date:
Subject: Re: Is autovacuum doing a wraparound-avoiding VACUUM?