[ADMIN] postgres streaming replication for HA - Mailing list 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