From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Thomas Poty <thomas(dot)poty(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issue on public schéma with Pg_restore |
Date: | 2018-04-26 17:30:09 |
Message-ID: | c5b2656e-adac-b7ab-fb30-1f748f935bdf@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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:
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Vitaliy Garnashevich | 2018-04-26 17:45:37 | Re: Long running INSERT+SELECT query |
Previous Message | Adrian Klaver | 2018-04-26 17:19:24 | Re: Long running INSERT+SELECT query |