public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rihad <[email protected]>
To: pgsql-general General <[email protected]>
Subject: Collation again here
Date: Thu, 8 Jan 2026 16:34:40 +0400
Message-ID: <[email protected]> (raw)

Hi, guys. Just pg_upgraded our PG from 13.x to 18.1, rebuilt all indexes 
concurrently and issued ALTER DATABASE foo REFRESH COLLATION VERSION

Everything's fine on the master server, no warnings etc. Then I set up a 
replica using pg_basebackup, and there when trying to access the DB 
using psql I get:


WARNING:  database "foo" has a collation version mismatch
DETAIL:  The database was created using collation version 43.0, but the 
operating system provides version 34.0.
HINT:  Rebuild all objects in this database that use the default 
collation and run ALTER DATABASE foo REFRESH COLLATION VERSION, or build 
PostgreSQL with the right library version.
psql (18.1)
Type "help" for help.


(and I can't issue those same commands on the read-only replica).


The OS are both FreeBSD, but the master runs 14.3, the replica runs 
13.5. PostgreSQL packages are built with ICU support by default, the 
versions used are identical: icu-76.1


Could it be that the OS (libc) needs to be the same version? I hoped it 
would be enough to use the same ICU.


Thanks for any tips.

view thread (2+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected]
  Subject: Re: Collation again here
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox