From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Hans Buschmann <buschmann@nidsa.net>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
Date: Wed, 17 May 2023 14:41:00 +0200
Message-ID: <e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com> (raw)
In-Reply-To: <5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net>
References: <17923-c791d260d83aa587@postgresql.org>
<6c53254e-3e03-aa73-6007-bc67397fd507@enterprisedb.com>
<5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net>
On 11.05.23 12:07, Hans Buschmann wrote:
> The problem is not at connection time (I only mentioned it for info).
>
>
> The problem is the endless repeating of these log entries without user
> login (cut a little bit at line end):
>
>
> 17:09:08 CEST 01000 1:> WARNING: database "template1" has a collation
> version mismatch
> 17:09:08 CEST 01000 2:> DETAIL: The database was created using
> collation version 2.36,
> 17:09:08 CEST 01000 3:> HINT: Rebuild all objects in this database
> that use the defaul
I guess this is from the autovacuum background processes. Maybe we
should disable the warnings for those?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: peter.eisentraut@enterprisedb.com, buschmann@nidsa.net, pgsql-bugs@lists.postgresql.org
Subject: Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
In-Reply-To: <e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox