Date: Fri, 28 Mar 2025 07:37:49 +0100
From: Matthias Apitz <guru@unixarea.de>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: COLLATION update in 13.1
Message-ID: <Z-ZDvVau16I_7txj@c720-1400094>
Reply-To: Matthias Apitz <guru@unixarea.de>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <c1f6a6487f3b1ffb1a761308a9e77b9aa7d6044f.camel@cybertec.at>
Archived-At: <https://www.postgresql.org/message-id/Z-ZDvVau16I_7txj%40c720-1400094>
Precedence: bulk

El día lunes, marzo 24, 2025 a las 07:27:21a. m. +0100, Laurenz Albe escribió:

> On Mon, 2025-03-24 at 06:57 +0100, Matthias Apitz wrote:
> > El día lunes, febrero 24, 2025 a las 12:41:05p. m. +0100, Laurenz Albe escribió:
> > > Perhaps I need not say that, but ALTER COLLATION ... REFRESH VERSION only
> > > makes the warning disappear.
> > > 
> > > If you want to avoid data corruption, rebuild all indexes on strings,
> > > then make the warning disappear.
> > 
> > One last question related to ALTER COLLATION ... In our clusters are also
> > the databases 'postgres', 'template0' and 'template1'. The latter we
> > never us and we CREATE new databases from 'template0'. 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.
> 
> ...

Thanks for your answer. Just for the record:

$ psql -Upostgres template0
Passwort für Benutzer postgres:
psql: FATAL:  database "template0" is not currently accepting connections
$

With 'template1' and 'postgres' it works fine.

	matthias

-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

Annalena Baerbock: "We are fighting a war against Russia ..." (25.1.2023)

I, Matthias, I am not at war with Russia.
Я не воюю с Россией.
Ich bin nicht im Krieg mit Russland.