Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date
Msg-id 3026.1486855735@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Stephen Frost <sfrost@snowman.net> writes:
> I'm not seeing a very simple answer for this, unfortunately.

I'm inclined to argue that it was a mistake to include any non-pinned
objects in pg_init_privs.  The reason initdb leaves some objects unpinned
is exactly because they can be dropped and recreated, and that means
that their "initial" privileges are not static system properties.

We might need to fix pg_dump too, but I think these entries in
pg_init_privs should simply not be there.

            regards, tom lane


pgsql-general by date:

Previous
From: Jan de Visser
Date:
Subject: Re: [GENERAL] Fwd: Query parameter types not recognized
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public