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@xxxxxxxxxxx