|
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,
|
