PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assuming pgha-proxy is the proxy server, and pgha1 and pgha2 are the BDR nodes, follow these steps to make HAProxy more compatible with BDR:

1. Add the following to the global section of the haproxy.cfg file:

global 
    stats socket /var/run/haproxy/sock level admin 

2. Ensure that the bk_db section of the haproxy.cfg file looks like this:

backend bk_db 
    option pgsql-check user haproxy_check 
 
    stick-table type ip size 1 
    stick on dst 
 
    server bdr_chicago pgha1:5432 check 
    server bdr_tokyo pgha2:5432 backup check 

3. Trigger HAProxy to reload the configuration file with the following command as a root-enabled user:

sudo systemctl reload haproxy