From: Peter 'PMc' Much <pmc@citylink.dinoex.sub.org>
To: Rihad <grihad@gmail.com>
Cc: Daniel Verite <daniel@manitou-mail.org>
Cc: pgsql-general General <pgsql-general@postgresql.org>
Subject: Re: Collation again here
Date: Thu, 8 Jan 2026 23:42:43 +0100
Message-ID: <aWAy44zgYdV8s0nB@cora.intra.daemon.contact> (raw)
In-Reply-To: <79758f11-44a2-4903-97e8-e61516aeedaa@gmail.com>
References: <8a739d96-83d1-482a-885d-3b76498c9e6e@manitou-mail.org>
<79758f11-44a2-4903-97e8-e61516aeedaa@gmail.com>
On Thu, Jan 08, 2026 at 05:26:47PM +0400, Rihad wrote:
! > As a general rule, you should indeed run the same OS version
! > for the primary and physical replicas.
! > Before Postgres version 15 this message did not exist, so the risks
! > of mismatch were silent but they existed just the same.
! >
! >
! > Best regards,
!
! Thanks. Both FreeBSD 13.5 & 14.3 are "current", just from different major
! branches. I wonder why they use such different locale/collate versioning,
! meaning that they differ roughly by that much as in 34 vs. 43. Maybe someone
! there mistyped 34?)
Hi, I ran into that same (surprizing) error when upgrading FreeBSD
13.x to 14.x.
In FreeBSD the major version switches are for exactly that purpose: to
change interfaces or libaries that may induce incompatibilities
The version numbers (34.0 vs 43.0) might mean anything, I don't
know; but they originate from these places in the OS distribution:
$ hd /usr/share/locale/en_US.UTF-8/LC_COLLATE | head -1
00000000 42 53 44 20 31 2e 30 0a 00 00 00 00 34 33 2e 30 |BSD 1.0.....43.0|
In Yor case, apparently the conclusion is that you need the same
FreeBSD major version throughout Your replication set.
-- PMc
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-general@postgresql.org
Cc: pmc@citylink.dinoex.sub.org, grihad@gmail.com, daniel@manitou-mail.org
Subject: Re: Collation again here
In-Reply-To: <aWAy44zgYdV8s0nB@cora.intra.daemon.contact>
* 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