[pgpool-general: 2370] pgpool and VRRP

[Athanasios | ZenGuard]

Dear list,
is it possible to provide HA for PGPool using VRRP? Something along the
lines of the following:

vrrp_script chk_pgpool {           # Requires keepalived-1.1.13
    script "killall -0 pgpool"     # cheaper than pidof
    interval 2                      # check every 2 seconds
    weight 2                        # add 2 points of prio if OK
}

vrrp_instance VI_1 {
    interface eth1
    <% if @hostname == "pgpool1" %>
    state MASTER
    <% else %>
    state SLAVE
    <% end %>
    virtual_router_id 52
    <% if @hostname == "pgpool1" %>
    priority 101                    # 101 on master, 100 on backup
    <% else %>
        priority 100
    <% end %>
    virtual_ipaddress {
        10.11.228.128
    }
    track_script {
        chk_pgpool
    }
}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140103/80d5b25b/attachment.htm>