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

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

  1. Move handling of database properties from pg_dumpall into pg_dump.

  2. Allow pg_dumpall to dump roles w/o user passwords

  3. Fix pg_dumpall to work for databases flagged as read-only.