pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Samed YILDIRIM <samed@reddoc.net>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: Sunil N Shinde <sunil.shinde@mastek.com>
Subject: Re: postgres streaming replication for HA
Date: Fri, 08 Sep 2017 09:51:35 +0300
Message-ID: <28541504853495@web3g.yandex.ru> (raw )
In-Reply-To: <HK2PR0601MB1873F65A786AD0A100112418EE950@HK2PR0601MB1873.apcprd06.prod.outlook.com >
References: <HK2PR0601MB1873F65A786AD0A100112418EE950@HK2PR0601MB1873.apcprd06.prod.outlook.com >
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 <sunil.shinde@mastek.com>:<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 & Regards,</span><span style="font-size:12pt;font-family:"Times New Roman",serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:"Trebuchet MS",sans-serif;color:#004080;">Sunil N Shinde</span></b><span style="font-size:12pt;font-family:"Times New Roman",serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:"Trebuchet MS",sans-serif;color:#004080;">Assistant Manager – DBA</span></b><span style="font-size:12pt;font-family:"Times New Roman",serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:"Trebuchet MS",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:"Times New Roman",serif;"><br /><br /><br /></span><b><span style="font-size:10pt;font-family:"Trebuchet MS",sans-serif;color:#004080;">Mob:- <span>9819002393</span></span></b><span style="font-size:12pt;font-family:"Times New Roman",serif;"></span></p><br /><p> </p><br /></div><br /></div><br /><br /></blockquote></div>
view thread (8+ messages) latest in thread
Message-ID: <28541504853495@web3g.yandex.ru>
Permalink: ../28541504853495@web3g.yandex.ru/
Also on: postgresql.org/message-id/28541504853495@web3g.yandex.ru
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: samed@reddoc.net, sunil.shinde@mastek.com
Subject: Re: postgres streaming replication for HA
In-Reply-To: <28541504853495@web3g.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox