Closed pulse-mind closed 3 months ago
After few tests, I did :
psql -d mydatabase
I was logged as postgres
grant create on schema public to mydatabase
And it works
This was a change introduced in PostgreSQL v15, so not something we can actually fix. It was deliberately tightened to encourage people to not use the public
schema. Ideally you should create a schema for your application, and use that instead:
https://www.crunchydata.com/blog/be-ready-public-schema-changes-in-postgres-15
Thank you for your time and your answer.
It looks like we need to add a right: https://medium.com/@dmitry.romanoff/postgresql-version-15-error-permission-denied-for-schema-public-dc8285c41e00