[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: =?UTF-8?Q?Re:_Issue_on_public_sch=c3=a9ma_with_Pg=5frestore?=
From: Adrian Klaver <adrian.klaver () aklaver ! com>
Date: 2018-04-26 17:30:09
Message-ID: c5b2656e-adac-b7ab-fb30-1f748f935bdf () aklaver ! com
[Download RAW message or body]
On 04/26/2018 07:52 AM, Thomas Poty wrote:
> Hi,
>
> About the minor version, we will plan the upgrade soon .
>
> So how did you revoke the privileges for PUBLIC in the above? [db source]
> => After creation of the database, I executed:
> revoke all on schema public from public;
Hmm:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5955d934194c3888f30318209ade71b53d29777f
Not sure if this patch is in 9.6.8 or not. The interesting part is:
"We had some pretty ad-hoc handling of the public schema ..."
"Previously, while it was normally not mentioned, --clean mode would
drop and recreate it, again causing headaches for non-superuser usage."
You might want to try without the --clean on the restore.
>
> Thanks for the 'no-op' .
>
> Thomas
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic