Re: [pg_dump] not dumping some default privileges

Feike Steenbergen wrote:
> On 23 October 2017 at 14:54, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
> wrote:
> >
> > Reinier Haasjes wrote:
> > > Hi,
> > >
> > > I noticed that pg_dump since 9.6 is missing some default privileges
> > Hmm, I can confirm that 9.6 seems to have this problem while 9.5 does
> > not seem to have it. Must have been broken at some point during the
> > extensive pg_dump patches in 9.6 ... I'll give this a look.
>
> in buildACLQueries there is a filter to exclude those acl's that match the
> pg_init_privs or default pg_catalog.acldefault for that role.

Ah, thanks, Feike.

So what is going on is that those commands don't actually have any
visible effect in pg_dump because they change the privileges from the
default state to a state that's identical to the default. I suppose
that makes sense.

However, I don't think Reinier would have gone to the trouble of
reporting the problem unless there was something actually being affected
by it. Am I mistaken?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services