From: | Sunil N Shinde <Sunil(dot)Shinde(at)mastek(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | postgres streaming replication for HA |
Date: | 2017-09-08 05:49:30 |
Message-ID: | HK2PR0601MB1873F65A786AD0A100112418EE950@HK2PR0601MB1873.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I am forming 2 node cluster of streaming replication for HA. I could able to succeed with the replication process.
But I am not able to complete the "switchover".
Version : postgresql-9.6
OS :RHEL7
Master Node Parameters:
wal_level = hot_standby
synchronous_commit = local
archive_mode = on
archive_command = 'cp %p /var/lib/pgsql/9.6/data/archive/%f'
max_wal_senders = 2
wal_keep_segments = 10
synchronous_standby_names = 'UWPGRECLUS2'
pb_hba.conf
# Localhost
host replication replica 127.0.0.1/32 md5
# PostgreSQL Master IP address
host replication replica 10.0.3.4/32 md5
# PostgreSQL SLave IP address
host replication replica 10.0.3.5/32 md5
Slave Node Parameters:
wal_level = hot_standby
synchronous_commit = local
max_wal_senders = 2
wal_keep_segments = 10
synchronous_standby_names = 'UWPGRECLUS2'
hot_standby = on
Replication is properly happening from master to slave. But I am not able to switchover between the nodes.
Can anyone please guide me in this regard?
Thanks & Regards,
Sunil N Shinde
Assistant Manager - DBA
Mastek Ltd | Mastek Millennium Center, Millennium Business Park, Mahape, Navi Mumbai-400710 .
Mob:- 9819002393
From | Date | Subject | |
---|---|---|---|
Next Message | Samed YILDIRIM | 2017-09-08 06:51:35 | Re: postgres streaming replication for HA |
Previous Message | Don Seiler | 2017-09-06 21:07:25 | Cascading Standby WALs Question |