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.