Configuring Connection Settings

max_connections = 200       # requires restart
# Prefer a pooler (PgBouncer) over very high values.

superuser_reserved_connections = 5

SET statement_timeout = '30s';
ALTER ROLE reporting SET statement_timeout = '2min';

ALTER SYSTEM SET idle_in_transaction_session_timeout = '5min';
-- Prevents long-held locks & bloat from forgotten BEGINs

tcp_keepalives_idle     = 60      # seconds before first keepalive

tcp_keepalives_interval = 10      # between keepalives

tcp_keepalives_count    = 6       # missed packets before drop

listen_addresses = '*'            # all; or '10.0.0.5,localhost'

port = 5432

unix_socket_directories = '/var/run/postgresql'
unix_socket_permissions = 0770