Message-ID: <f39b5db0281e0d026579ca9ed147905d845ee9d5.camel@cybertec.at>
Subject: Re: COLLATION update in 13.1
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Matthias Apitz <guru@unixarea.de>
Cc: pgsql-general@lists.postgresql.org
Date: Fri, 28 Mar 2025 08:17:04 +0100
In-Reply-To: <Z-ZDvVau16I_7txj@c720-1400094>
References: 
	<CAHzebO-2qy2RkrhTvqPs8=6Ju_6-7C=MSumVMZxTs7zRYp-6mA@mail.gmail.com>
	 <20250224023225.197cac12@ardentperf.com>
	 <6118973a513658c4a46d9399f3691d0ef21672e8.camel@cybertec.at>
	 <Z-D0PoRbfrCufWdu@c720-1400094>
	 <c1f6a6487f3b1ffb1a761308a9e77b9aa7d6044f.camel@cybertec.at>
	 <Z-ZDvVau16I_7txj@c720-1400094>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/f39b5db0281e0d026579ca9ed147905d845ee9d5.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-03-28 at 07:37 +0100, Matthias Apitz wrote:
> Anyway, does it make sense to ALTER COLLATION in these databases as well?
> >=20
> > I would say so, yes.=C2=A0 At least on the template you are using for n=
ew databases.
>=20
> $ psql -Upostgres template0
> Passwort f=C3=BCr Benutzer postgres:
> psql: FATAL:=C2=A0 database "template0" is not currently accepting connec=
tions
> $
>=20
> With 'template1' and 'postgres' it works fine.

You'd have to temporarily allow connections and reset it once you are done.

  ALTER DATABASE template0 ALLOW_CONNECTIONS TRUE;
  \c template0
  ALTER COLLATION ... REFRESH VERSION;
  ALTER DATABASE template0 ALLOW_CONNECTIONS FALSE;
  \q

Yours,
Laurenz Albe