Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>

To: Hans Buschmann <buschmann@nidsa.net>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2023-05-17T12:41:00Z

Lists: pgsql-bugs

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?