It would be better to set template to template1 in postgresql_database: template1 is default behaviour in PostgreSQL and more importantly some cloud providers like GCP set owner of template0 schema to inaccessible superuser (in case of GCP it is cloudsqladmin). So there is no way to change that later without recreating the database.
I understand that this will be breaking changes and could affect users of the provider, but it will also save a lot of work for people creating new databases on GCP or AWS.
Hi there,
It would be better to set
template
totemplate1
inpostgresql_database
:template1
is default behaviour in PostgreSQL and more importantly some cloud providers like GCP set owner oftemplate0
schema to inaccessible superuser (in case of GCP it iscloudsqladmin
). So there is no way to change that later without recreating the database.I understand that this will be breaking changes and could affect users of the provider, but it will also save a lot of work for people creating new databases on GCP or AWS.
Thank you!
References
Similar issue with AWS: