From: Bruno Wolff III <bruno@wolff.to>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Thomas Kellerer <shammat@gmx.net>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Postgres 15 upgrades and template1 public schema
Date: Sat, 5 Nov 2022 07:18:36 -0500
Message-ID: <20221105121836.GA7716@wolff.to> (raw)
In-Reply-To: <2949522.1666223992@sss.pgh.pa.us>
References: <20221019203602.GA6563@wolff.to>
<54d740ed-1158-c8d4-4cae-15c06e95c9e6@gmx.net>
<20221019224828.GA11721@wolff.to>
<2949522.1666223992@sss.pgh.pa.us>
On Wed, Oct 19, 2022 at 19:59:52 -0400,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>The release notes could probably use some tweaking here. It looks to
>me like pg_dumpall (and hence pg_upgrade) will adjust the ownership and
>permissions of template1's public schema to match what was in the old
>installation, but it doesn't touch template0. Hence, whether a
>"newly-created database in an existing cluster" has the old or new
>properties of the public schema will depend on whether you clone it
>from template1 or template0. That definitely needs explained, and
>maybe we should recommend that DBAs consider manually changing
>what's in template1.
I didn't see any changes related to this in the first draft of the 15.1
release notes. Since I got the impression from the above that there
might be a change, I'm sending this as a reminder.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: bruno@wolff.to, tgl@sss.pgh.pa.us, bruce@momjian.us, shammat@gmx.net
Subject: Re: Postgres 15 upgrades and template1 public schema
In-Reply-To: <20221105121836.GA7716@wolff.to>
References: <20221019203602.GA6563@wolff.to> <54d740ed-1158-c8d4-4cae-15c06e95c9e6@gmx.net> <20221019224828.GA11721@wolff.to> <2949522.1666223992@sss.pgh.pa.us> <20221105121836.GA7716@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox