postgres.cfg

#  vim:ts=4:sts=4:sw=4:et
#
#  Author: Hari Sekhon
#  Date: 2018-02-17 13:36:42 +0000 (Sat, 17 Feb 2018)
#
#  https://github.com/HariSekhon/HAProxy-configs
#
#  License: see accompanying Hari Sekhon LICENSE file
#
#  If you're using my code you're welcome to connect with me on LinkedIn and optionally send me feedback to help steer this or other code I publish
#
#  https://www.linkedin.com/in/HariSekhon
#

# ============================================================================ #
#                     H A P r o x y  -  P o s t g r e S Q L
# ============================================================================ #

frontend postgres
    description "PostgreSQL"
    bind *:5432
    mode tcp
    option tcplog
    default_backend postgres

backend postgres
    description "PostgreSQL"
    #balance leastconn
    balance first
    mode tcp
    acl internal_networks src 192.168.0.0/16 172.16.0.0/12 10.0.0.0/8 127.0.0.1
    tcp-request content reject if ! internal_networks
    option pgsql-check user postgres
    server postgres postgres:5432 check
    server postgresql postgresql:5432 check backup
    server docker docker:5432 check backup
    server 192.168.99.100 192.168.99.100:5432 check backup