Re: COLLATION update in 13.1

[Laurenz Albe <laurenz.albe@xxxxxxxxxxx>]

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?
> > 
> > I would say so, yes.  At least on the template you are using for new databases.
> 
> $ psql -Upostgres template0
> Passwort für Benutzer postgres:
> psql: FATAL:  database "template0" is not currently accepting connections
> $
> 
> 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