On 04/25/2018 11:07 AM, Thomas Poty wrote:
> Hello,
> Here is the context :
Postgres version?
> I have a db db1 with a schéma public on cluster C1.
> This schéma doesn't have any privileges on public role.
> I have a dump of this db.
What was the dump command?
> On an other cluster C2, the template1 doesn't contain schema public.
> I have restored db1 on cluster C2 and i saw public role had the
> privilege create on the schéma public.
What was the restore command?
>
> I cannot explain this
>
> Thank you.
>
> Thomas?
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com