Most likely due to a different C lib version on the different OS.
All;
I have 2 aws ec2 nodes and I want to setup a hot standby.
The master is running amazon linux and here are the postgres packages installed:
[root@ip-10-0-3-55 ~]# rpm -qa | grep postgres
postgresql-private-libs-15.2-1.module_el9+264+92dde3f0.x86_64
postgresql-15.2-1.module_el9+264+92dde3f0.x86_64
postgresql-server-15.2-1.module_el9+264+92dde3f0.x86_64
The standby is running Alma 8 and here are the postgres packages installed:
[root@ip-10-0-3-228 ~]# rpm -qa | grep postgres
postgresql15-server-15.11-1PGDG.rhel8.x86_64
postgresql15-libs-15.11-1PGDG.rhel8.x86_64
postgresql15-15.11-1PGDG.rhel8.x86_64
postgresql15-contrib-15.11-1PGDG.rhel8.x86_64
Once I run pg_basebackup I start the standby and get this:
[postgres@ip-10-0-3-228 ~]$ /usr/pgsql-15/bin/pg_ctl start
waiting for server to start....2025-02-24 07:07:26.800 UTC [180985] LOG: redirecting log output to logging collector process
2025-02-24 07:07:26.800 UTC [180985] HINT: Future log output will appear in directory "log".
done
server started
[postgres@ip-10-0-3-228 ~]$ psql
WARNING: database "postgres" has a collation version mismatch
DETAIL: The database was created using collation version 2.34, but the operating system provides version 2.28.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
and once the db is online I check and the standby is not in recovery mode:
psql (15.11)
Type "help" for help.
postgres=# select pg_is_in_recovery();
pg_is_in_recovery
-------------------
f
(1 row)
postgres=#
Thanks in advance for any advice
-- Thanks,
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.
