Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: Postgresql streaming replication
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>
Date: Tue, 28 May 2024 08:55:06 -0600
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com>
References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>
To: dbadmin@pangburngroup.com
Archived-At: 
 <https://www.postgresql.org/message-id/566DFBB0-A057-4069-A1F0-1AEFB38281F5%40elevated-dev.com>
Precedence: bulk

> On May 28, 2024, at 8:50=E2=80=AFAM, Prasanth =
<dbadmin@pangburngroup.com> wrote:
>=20
> Hi,
>=20
> We are running postgresql 16 on debian 12. I tried to create a hot =
standby on a different server that is running alma linux 9.  After doing =
the backbackup and starting the server seems like the replication is =
going fine. When I tried to login to the standby to run some queries got =
the below message. Postgresql is installed using rpm.
>=20
> DETAIL:  The database was created using collation version 2.36, but =
the operating system provides version 2.34.
> HINT:  Rebuild all objects in this database that use the default =
collation and run ALTER DATABASE database_name REFRESH COLLATION =
VERSION, or build PostgreSQL with the right library version.

Yep. Different versions of Linux changed collation rules in the glibc =
locale implementations. You will not be able to do streaming replication =
between those two Linux versions with those two builds of PostgreSQL. =
You will have to either:

- get Linux versions with same (or close enough) glibc versions

- figure out how to build PostgreSQL yourself with a compatible version