<html><head></head><body><div class="ydp60d2bed2yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>1. Yes there is a hook: the if_up_cmd configuration is normally used to acquire the VIP (delegate IP) but you can execute any script you want</div><div>2. If you have 3 pgpool nodes then you can survive the lost of one node. If you lose a second node then there is not enough left to acquire a majority of the vote and so the surviving node cannot elect itself as a leader. This is normal, it is a protection against a split-brain scenario. I don't know if it is possible to change this behavior (maybe with trusted_server config ?) but it is usually not a good idea to change this behavior.<br></div><div><br></div><div class="ydp60d2bed2signature">Regards, Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp2867b234yahoo_quoted_8151134096" class="ydp2867b234yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, May 15, 2019, 11:58:39 AM GMT+2, Lakshmi Raghavendra <lakshmiym108@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp2867b234yiv3381669798"><div><div dir="ltr">Hi Pgpool Team,<div><br clear="none"></div><div> Could you please share some light on the below queries.</div><div><br clear="none"></div><div>Thanks And Regards,</div><div><br clear="none"></div><div> Lakshmi Y M </div></div><br clear="none"><div class="ydp2867b234yiv3381669798yqt7050291410" id="ydp2867b234yiv3381669798yqt75057"><div class="ydp2867b234yiv3381669798gmail_quote"><div class="ydp2867b234yiv3381669798gmail_attr" dir="ltr">On Fri, May 10, 2019 at 7:07 PM Lakshmi Raghavendra <<a shape="rect" href="mailto:lakshmiym108@gmail.com" rel="nofollow" target="_blank">lakshmiym108@gmail.com</a>> wrote:<br clear="none"></div><blockquote class="ydp2867b234yiv3381669798gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div dir="ltr"><div dir="ltr"><div>Hi,</div><div>I am trying pgpool for automatic faliover on my postgresql cluster using the watchdog feature</div><div>Wanted to know a couple of things </div><div>1. Are there any hooks when pgpool re-elects next pgpool master ? wanted to run some customization during this time</div><div>2. Will the VIP get assigned ony if there are more than 1 node present in the pgpool cluster? I had 3 nodes where i had pgpool running. When the 1st and 2nd node's pgpool was shut i was expecting the 3rd node to acquire the VIP but it didn't happen. And if my understanding was right i was thinking of using the VIP in my database connection string (Since it will always be with pgpool master who can connect to my postgresql primary). Now if the 3rd node is not acquiring the VIP, i could not use it my connection string. Correct me if my understanding is wrong</div><div><br clear="none"></div><div><br clear="none"></div><div>Thanks in advance</div><div><br clear="none"></div><div> Lakshmi Y M</div></div></div>
</blockquote></div></div></div></div><div class="ydp2867b234yqt7050291410" id="ydp2867b234yqt20336">_______________________________________________<br clear="none">pgpool-general mailing list<br clear="none"><a shape="rect" href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br clear="none"><a shape="rect" href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br clear="none"></div></div>
</div>
</div></body></html>