le-phare / le-phare.github.io

The Faros site
https://faros.lephare.com
4 stars 2 forks source link

Add Postgresql 15 role requirement #108

Closed thislg closed 4 months ago

thislg commented 1 year ago

See https://www.postgresql.org/about/news/postgresql-15-released-2526/#:%7E:text=PostgreSQL%2015%20also%20revokes%20the%20CREATE%20permission%20from%20all%20users%20except%20a%20database%20owner%20from%20the%20public

Since Postgresql 15 users do not have CREATE privileges on public schema. We should add a requirement to grant this privilege to the application user so Doctrine can create tables.