Re: postgres streaming replication for HA

[Samed YILDIRIM <samed@xxxxxxxxxx>]

Hi Shinde,

Do you trying swithover manually? Or do you use any manager or script to handle switchover operation?

Best regards.

--
Yandex.Mail mobil uygulamasından gönderildi

08:51, 8 Eylül 2017, Sunil N Shinde <sunil.shinde@xxxxxxxxxx>:

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