Feedback-ID: i131946ab:Fastmail
Message-ID: <e87a8b12-7564-cd3a-f3c1-90e2005bb4e8@enterprisedb.com>
Date: Wed, 17 May 2023 14:41:00 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.10.0
Subject: Re: AW: BUG #17923: Excessive warnings of collation version mismatch
 in logs
To: Hans Buschmann <buschmann@nidsa.net>,
 "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
References: <17923-c791d260d83aa587@postgresql.org>
 <6c53254e-3e03-aa73-6007-bc67397fd507@enterprisedb.com>
 <5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net>
Content-Language: en-US
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: <5d3fa6cf2dd7489dba0e087e7e6a164e@nidsa.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/e87a8b12-7564-cd3a-f3c1-90e2005bb4e8%40enterprisedb.com>
Precedence: bulk

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?