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@xxxxxxxxxxx, 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.
