Hot Standby setup - collation version mismatch

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Hot Standby setup - collation version mismatch
Date: 2025-02-25 17:43:16
Message-ID: b1280a26-bf73-4c0b-9f99-99294dee4d4f@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)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(at)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(at)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(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-02-25 17:47:45 Re: Hot Standby setup - collation version mismatch
Previous Message Aleksey M Boltenkov 2025-02-25 15:14:16 Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL