postgres streaming replication for HA

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

Responses

Browse pgsql-admin by date

  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