EnterpriseDB / repmgr

A lightweight replication manager for PostgreSQL (Postgres)
https://repmgr.org/
Other
1.56k stars 251 forks source link

**High Priority** repmgr with multi slaves replication solution is not working in k8s environment #836

Open Bhagi33 opened 10 months ago

Bhagi33 commented 10 months ago

Hi Team,

On kubernetes i am deploying postgres with 1 master(postgres-master-0), 1 witness(witness-slave-0-0) 2 slaves: slave1(witness-slave-1-0) & slave2(witness-slave-2-0)

But repmgr replication solution is not working. when i register 2 standby's , they are trying to run as primary . i am attaching the screenshots and its configuration parameters. please guide me to fix the issue.

-> Below configuration is of Master and standby's

cat /persistent/postgres/postgresql/pg_hba.conf

local replication repmgr trust host replication repmgr 127.0.0.1/32 trust host replication repmgr 16.0.0.0/16 trust

local repmgr repmgr trust host repmgr repmgr 127.0.0.1/32 trust host repmgr repmgr 16.0.0.0/16 trust local postgres embahar trust host replication repmgr 0.0.0.0/0 trust host repmgr repmgr 0.0.0.0/0 trust host postgres grafmon 0.0.0.0/0 md5

witness-slave-1-0:/home/postgres$ cat /persistent/postgres/postgresql/postgresql.conf listen_addresses = '*' shared_preload_libraries = 'repmgr,pg_cron' max_wal_senders = 10 max_replication_slots = 10 wal_level = 'replica' hot_standby = on archive_mode = on archive_command = '/bin/true'

--> Witenss configuration

cat /persistent/postgres/postgresql/pg_hba.conf local replication repmgr trust host replication repmgr 127.0.0.1/32 trust host replication repmgr 16.0.0.0/16 trust

local repmgr repmgr trust host repmgr repmgr 127.0.0.1/32 trust host repmgr repmgr 16.0.0.0/16 trust local postgres embahar trust host replication repmgr 0.0.0.0/0 trust host repmgr repmgr 0.0.0.0/0 trust host postgres grafmon 0.0.0.0/0 md5

cluster events pg-hba-conf postgres-conf repmgr cluster show witness-slave-0-0:/home/postgres$ cat /persistent/postgres/postgresql/postgresql.conf listen_addresses = '*' shared_preload_libraries = 'repmgr,pg_cron' witness-slave-0-0:/home/postgres$