[pgpool-general: 6556] Re: Pgpool query

[Pierre Timmermans]

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 want2. 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.

Regards, Pierre 

    On Wednesday, May 15, 2019, 11:58:39 AM GMT+2, Lakshmi Raghavendra <lakshmiym108 at gmail.com> wrote:  
 
 Hi Pgpool Team,
     Could you please share some light on the below queries.
Thanks And Regards,
   Lakshmi Y M 
On Fri, May 10, 2019 at 7:07 PM Lakshmi Raghavendra <lakshmiym108 at gmail.com> wrote:

Hi,I am trying pgpool for automatic faliover on my postgresql cluster using the watchdog featureWanted to know a couple of things 1. Are there any hooks when pgpool re-elects next pgpool master ? wanted to run some customization during this time2. 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

Thanks in advance
   Lakshmi Y M
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190515/aa20f8ae/attachment.html>