<div dir="ltr">Dear list,<div>is it possible to provide HA for PGPool using VRRP? Something along the lines of the following:</div><div><br></div><div><div>vrrp_script chk_pgpool { # Requires keepalived-1.1.13</div>
<div> script "killall -0 pgpool" # cheaper than pidof</div><div> interval 2 # check every 2 seconds</div><div> weight 2 # add 2 points of prio if OK</div>
<div>}</div><div><br></div><div>vrrp_instance VI_1 {</div><div> interface eth1</div><div> <% if @hostname == "pgpool1" %></div><div> state MASTER</div><div> <% else %></div><div> state SLAVE</div>
<div> <% end %></div><div> virtual_router_id 52</div><div> <% if @hostname == "pgpool1" %></div><div> priority 101 # 101 on master, 100 on backup</div><div> <% else %></div>
<div> priority 100</div><div> <% end %></div><div> virtual_ipaddress {</div><div> 10.11.228.128</div><div> }</div><div> track_script {</div><div> chk_pgpool</div><div> }</div><div>
}</div></div><div><br></div></div>