Re: Postgres 15 upgrades and template1 public schema

[Thomas Kellerer <shammat@xxxxxxx>]

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.