Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: AW: BUG #17923: Excessive warnings of collation version mismatch in logs
Date
Msg-id e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com
Whole thread Raw
In response to AW: BUG #17923: Excessive warnings of collation version mismatch in logs  (Hans Buschmann <buschmann@nidsa.net>)
Responses AW: AW: BUG #17923: Excessive warnings of collation version mismatch in logs  (Hans Buschmann <buschmann@nidsa.net>)
List 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?



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM
Next
From: Joe Conway
Date:
Subject: Re: BUG #17937: Corrupt Indexes after reusing DRBD Device on new VM