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