From: Prasanth <dbadmin@pangburngroup.com>
To: pgsql-admin@postgresql.org
Subject: Postgresql streaming replication
Date: Tue, 28 May 2024 09:50:47 -0500
Message-ID: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com> (raw)
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.
Thanks,
Prasanth
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: dbadmin@pangburngroup.com
Subject: Re: Postgresql streaming replication
In-Reply-To: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.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