Re: [HACKERS] Refactor handling of database attributes between pg_dump and pg_dumpall
Haribabu Kommi <kommi.haribabu@gmail.com>
From: Haribabu Kommi <kommi.haribabu@gmail.com>
To: Vaishnavi Prabakaran <vaishnaviprabakaran@gmail.com>
Cc: Michael Paquier <michael.paquier@gmail.com>,
Robert Haas <robertmhaas@gmail.com>, Thomas Munro <thomas.munro@enterprisedb.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
Andreas Karlsson <andreas@proxel.se>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-01-05T05:32:05Z
Lists: pgsql-hackers
Attachments
- pg_dump-and-pg_dumpall-database-handling-refactoring_v12.patch (application/octet-stream) patch v12
On Fri, Jan 5, 2018 at 2:54 PM, Vaishnavi Prabakaran <
vaishnaviprabakaran@gmail.com> wrote:
>
> On Wed, Dec 13, 2017 at 1:50 PM, Haribabu Kommi <kommi.haribabu@gmail.com>
> wrote:
>
>> Rebased patch attached that fixes the documentation build problem.
>>
>> Latest patch applies without noise. And here are some minor comments
>
Thanks for the review.
> + <varlistentry>
> + <term><option>--set-db-properties</option></term>
> + <listitem>
> + <para>
> + This option is to skip create database command without ignoring
> the rest
> + of the DATABASE specific commands and it is used when the
> database already
> + exists in the restore location. This option cannot be used with
> either of
> + <option>-C/--create</option> or <option>-c/--clean</option>
> options.
> + </para>
>
> I see the description is framed based on previous flag "
> --skip-default-create-db" , and I think this needs to be re-phrased to
> describe what it does , e.g: This option is to set database properties for
> already existing database without issuing create database command ....".
>
Updated with more details.
+ printf(_(" --set-db-properties dump db properties, for use by
> upgrade utilities only\n"));
> After the discussion about its usage up-thread, this needs to be corrected.
>
Corrected.
Updated patch attached.
Regards,
Hari Babu
Fujitsu Australia
Commits
-
Move handling of database properties from pg_dumpall into pg_dump.
- b3f8401205af 11.0 landed
-
Allow pg_dumpall to dump roles w/o user passwords
- 9a83d56b38c8 10.0 cited
-
Fix pg_dumpall to work for databases flagged as read-only.
- 4bd371f6f886 9.4.0 cited