From: Samed YILDIRIM <samed@reddoc.net>
To: Anjul Tyagi <anjul@ibosstech-us.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Logical Replication - Rep Manager
Date: Wed, 26 Aug 2020 09:50:29 +0300
Message-ID: <363131598424371@mail.yandex.com.tr> (raw)
In-Reply-To: <ema35a8831-3413-4c3d-999d-a2ef2d0f4aa0@iboss01108>
References: <ema35a8831-3413-4c3d-999d-a2ef2d0f4aa0@iboss01108>
<div><div>Hi Anjul,</div><div> </div><div>I haven't tested, but specifying multiple host in connection string may solve your issue.</div><div> </div><div>For example;</div><div>create subscription sub1</div><div> connection 'host=192.168.100.25,192.168.100.50,192.168.56.20 dbname=prod_db user=logical_rep password=123'</div><div> publication pub_for_report;</div><div> </div><div><a href="https://www.postgresql.org/docs/12/libpq-connect.html#LIBPQ-MULTIPLE-HOSTS">https://www.postg... regards.</div><div>Samed YILDIRIM</div><div> </div><div>25.08.2020, 20:34, "Anjul Tyagi" <anjul@ibosstech-us.com>:</div><blockquote><div style="font-family:'calibri';font-size:11pt"><div>Hi Team,</div><div> </div><div>We are planning to implement the Rep Manager in our environment to manage the replication. While reading the documentation we found out that if primary goes down. We can promote one of the standby server and make it primary. However we have one reporting server that we are replicating specific table data via logical replication. While doing testing in lower environment, we noticed when we primary goes down and we promote the standby server, our replication also breaks. Do we have any option and suggestion to handle the logical replication in case of failure.</div><div> </div><div>Thanks in advance. </div><div> </div><div><div><div style="font-family:'tahoma'"><div> </div><div> </div><div> </div><div><p style="font-family:'calibri' , sans-serif;font-size:11pt;margin:0in 0in 0pt 0in"><span lang="EN-IN" style="color:#222a35">Regards,</span></p><p style="font-family:'calibri' , sans-serif;font-size:11pt;margin:0in 0in 0pt 0in"><span lang="EN-IN" style="color:#222a35">Anjul <strong>TYAGI</strong></span></p><p style="font-family:'calibri' , sans-serif;font-size:11pt;margin:0in 0in 0pt 0in"><strong><span lang="EN-IN" style="color:#17365d"> </span></strong></p><p style="font-family:'calibri' , sans-serif;font-size:11pt;margin:0in 0in 0pt 0in"><strong><span lang="EN-GB" style="color:green;font-family:'webdings';font-size:16pt">ü</span><span lang="EN-GB" style="color:green"> </span><span style="color:green;font-size:7.5pt">Go Green</span></strong></p></div></div></div></div><div> </div></div></blockquote>
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, anjul@ibosstech-us.com
Subject: Re: Logical Replication - Rep Manager
In-Reply-To: <363131598424371@mail.yandex.com.tr>
* 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