Hi!
You should not use streaming replication with radically different operating systems because of collation differences. Use logical replication instead.
Best regards, Matti Linnanvuori
On Tuesday, May 28th, 2024 at 17.50, 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.
Thanks,
Prasanth