Horton

Re: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly

Haribabu Kommi <kommi.haribabu@gmail.com>

View thread View on postgr.es
From: Haribabu Kommi <kommi.haribabu@gmail.com>
To: "Bossart, Nathan" <bossartn@amazon.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2019-05-02T04:08:59Z
Lists: pgsql-bugs 
On Thu, May 2, 2019 at 9:28 AM Bossart, Nathan <bossartn@amazon.com> wrote:

> It looks like the bug reporting form destroyed the patch.  I've
> attached it again here.
>

Thanks, for the patch.  Just to make sure that we didn't miss, a similar
problem
can occur in v10 and v9.6 pg_dumpall. In v11, the database acl's dumping
mechanism is moved from pg_dumpall to pg_dump.

a similar change in pg_dumpall "dumpCreateDB" function works for 10 and 9.6.

Regards,
Haribabu Kommi
Fujitsu Australia

Commits

  1. Fix ordering of GRANT commands in pg_dumpall for database creation

  2. Fix ordering of GRANT commands in pg_dump for database creation