RepMgr

https://www.enterprisedb.com/postgres-tutorials/how-implement-repmgr-postgresql-automatic-failover

psql -c 'IDENTIFY_SYSTEM' 'host=172.16.0.241 dbname=postgres user=streaming_barman replication=1'

https://www.scaleway.com/en/docs/tutorials/back-up-postgresql-barman/

Su entrambi i nodi:

curl https://dl.enterprisedb.com/default/release/get/15/rpm | sudo bash
yum -y  install repmgr15*

Sul Master:

max_wal_senders = 10
max_replication_slots = 10
wal_level = 'hot_standby'
# or 'replica' or 'logical'
hot_standby = on
archive_mode = on
archive_command = '/bin/true'
shared_preload_libraries = 'repmgr'

/usr/pgsql-15/bin/repmgr -h psql01 -U repmgr -d repmgr -f /var/lib/pgsql/repmgr.conf standby clone --dry-run

/usr/pgsql-15/bin/repmgr -h psql01 -U repmgr -d repmgr -f /var/lib/pgsql/repmgr.conf standby clone

Avviare il nodo secondario:

/usr/pgsql-15/bin/repmgr -f /var/lib/pgsql/repmgr.conf standby register