PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this recipe, we will need only one PostgreSQL server, and one server for HAProxy. We'll assume the PostgreSQL server is named pgha1, and the HAProxy is named pgha-proxy. In addition to this, the IP address for pg1 is 10.0.30.1, while pgha-proxy uses 10.0.30.20. Follow these steps to configure HAProxy on the pgha-proxy server:

1. Create a PostgreSQL database role on pgha1 by executing this SQL:

CREATE ROLE haproxy_check;

2. Create or modify a file named haproxy.cfg in the /etc/haproxy directory with the following content:

global maxconn 100 defaults log global mode tcp retries 2 timeout client 30m timeout connect 4s timeout server 30m timeout check 5s frontend ft_postgresql bind *:5432 default_backend bk_db backend bk_db ...