Postgres config

pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# Remote VPN/IP connections
# Replace xxx.xxx.xx.xxx with your VPN IP
host    all             all             xxx.xxx.xx.xxx/32       scram-sha-256

# Local Unix-socket connections
local   all             all                                     scram-sha-256

# IPv4 local connections
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             172.16.0.0/12           scram-sha-256

# Docker internal network
host    all             all             192.168.0.0/16          scram-sha-256

# Local network
host    all             all             10.0.0.0/8              scram-sha-256

# Private network range

# IPv6 local connections
host    all             all             ::1/128                 scram-sha-256

# Local replication
local   replication     all                                     scram-sha-256
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

# Reject all other connections
host    all             all             all                     reject