Re: postgres streaming replication for HA

Hi Shinde,<div><br /></div><div>Do you trying swithover manually? Or do you use any manager or script to handle switchover operation?</div><div><br /></div><div>Best regards.</div><div><br />-- <br />Yandex.Mail mobil uygulamasından gönderildi<br /><br />08:51, 8 Eylül 2017, Sunil N Shinde &lt;sunil(dot)shinde(at)mastek(dot)com&gt;:<br /><blockquote><br /><br /><br /><br /><br /><br /><div lang="EN-IN" link="blue" vlink="purple"><br /><div><br /><p>Hi,</p><br /><p> </p><br /><p>I am forming 2 node cluster of streaming replication for HA. I could able to succeed with the replication process.</p><br /><p>But I am not able to complete the “<b>switchover</b>”. <br /></p><br /><p> </p><br /><p>Version : postgresql-9.6</p><br /><p>OS :RHEL7</p><br /><p> </p><br /><p>Master Node Parameters:</p><br /><p>                                                <i><span style="font-size:9pt;font-family:Cambria,serif;">wal_level = hot_standby <br /></span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                synchronous_commit = local</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                archive_mode = on <br /></span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                archive_command = 'cp %p /var/lib/pgsql/9.6/data/archive/%f'                   <br /></span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                max_wal_senders = 2</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                wal_keep_segments = 10</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                synchronous_standby_names = 'UWPGRECLUS2'</span></i></p><br /><p> </p><br /><p>                                pb_hba.conf      </p><br /><p style="margin-left:54pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;"># Localhost</span></i></p><br /><p style="margin-left:72pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;">host    replication     replica          127.0.0.1/32            md5          <br /></span></i></p><br /><p style="margin-left:72pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;"># PostgreSQL Master IP address</span></i></p><br /><p style="margin-left:72pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;">host    replication     replica          10.0.3.4/32            md5</span></i></p><br /><p style="margin-left:72pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;"># PostgreSQL SLave IP address</span></i></p><br /><p style="margin-left:72pt;"><i><span style="font-size:9pt;font-family:Cambria,serif;">host    replication     replica          10.0.3.5/32            md5</span></i></p><br /><p> </p><br /><p>Slave Node Parameters:</p><br /><p>                                                <i><span style="font-size:9pt;font-family:Cambria,serif;">wal_level = hot_standby <br /></span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                synchronous_commit = local</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                max_wal_senders = 2</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                wal_keep_segments = 10</span></i></p><br /><p><i><span style="font-size:9pt;font-family:Cambria,serif;">                                                synchronous_standby_names = 'UWPGRECLUS2'</span></i></p><br /><p>                                                <i><span style="font-size:9pt;font-family:Cambria,serif;">hot_standby = on</span></i></p><br /><p> </p><br /><p></p><br /><p><b>Replication is properly happening from master to slave. But I am not able to switchover between the nodes.</b></p><br /><p> </p><br /><p>Can anyone please guide me in this regard?</p><br /><p> </p><br /><p> </p><br /><p><span style="font-size:10pt;color:#004080;">Thanks &amp; Regards,</span><span style="font-size:12pt;font-family:&quot;Times New Roman&quot;,serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:&quot;Trebuchet MS&quot;,sans-serif;color:#004080;">Sunil N Shinde</span></b><span style="font-size:12pt;font-family:&quot;Times New Roman&quot;,serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:&quot;Trebuchet MS&quot;,sans-serif;color:#004080;">Assistant Manager – DBA</span></b><span style="font-size:12pt;font-family:&quot;Times New Roman&quot;,serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:&quot;Trebuchet MS&quot;,sans-serif;color:#004080;">Mastek Ltd | Mastek Millennium Center, Millennium Business Park, Mahape, Navi Mumbai-400710 .</span></b><span style="font-size:12pt;font-family:&quot;Times New Roman&quot;,serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:&quot;Trebuchet MS&quot;,sans-serif;color:#004080;">Mob:- <span>9819002393</span></span></b><span style="font-size:12pt;font-family:&quot;Times New Roman&quot;,serif;"></span></p><br /><p> </p><br /></div><br /></div><br /><br /></blockquote></div>