RepMgr: differenze tra le versioni

Da GazziNet.
Vai alla navigazione Vai alla ricerca
(Creata pagina con " https://www.enterprisedb.com/postgres-tutorials/how-implement-repmgr-postgresql-automatic-failover")
 
Nessun oggetto della modifica
 
Riga 1: Riga 1:
   
   
  https://www.enterprisedb.com/postgres-tutorials/how-implement-repmgr-postgresql-automatic-failover
  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

Versione attuale delle 19:33, 12 giu 2023

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