pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Scott Ribe <scott_ribe@elevated-dev.com>
To: dbadmin@pangburngroup.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql streaming replication
Date: Tue, 28 May 2024 08:55:06 -0600
Message-ID: <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com> (raw)
In-Reply-To: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>
References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>

> On May 28, 2024, at 8:50 AM, Prasanth <dbadmin@pangburngroup.com> wrote:
> 
> Hi,
> 
> 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.
> 
> 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

view thread (8+ messages)  latest in thread

Message-ID: <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com>
Permalink:  ../566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com/
Also on:    postgresql.org/message-id/566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com

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: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, dbadmin@pangburngroup.com
  Subject: Re: Postgresql streaming replication
  In-Reply-To: <566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com>

* 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