Bruno Wolff III schrieb am 19.10.2022 um 22:36:
> I noticed when I did an upgrade from Postgres 14 to 15 that the
> public schema in template1 was still owned by postgres instead of
> pg_database_owner. I was expecting it to change because the release
> notes said that new database clusters would have that. But shouldn't
> new clusters use what is set in template1?
This is explained in the release notes:
The change applies to new database clusters and to newly-created
databases in existing clusters.
Upgrading a cluster or restoring a database dump will preserve
public's existing permissions.