pg_hba.conf Generator

Build pg_hba.conf rules with a visual form.

# PostgreSQL Client Authentication Configuration File
# Generated by MyDBA.dev pg_hba.conf Generator
#
# TYPE  DATABASE  USER  ADDRESS  METHOD  [OPTIONS]

# Allow local connections for superuser via peer auth
local	all	postgres	peer
# Allow IPv4 local connections with password
host	all	all	127.0.0.1/32	scram-sha-256
# Allow IPv6 local connections with password
host	all	all	::1/128	scram-sha-256

Want continuous PostgreSQL monitoring?

Start free with one primary or standalone PostgreSQL instance and all its databases. Monitoring, alerts, query insights, index advice, team access and every non-AI feature included. No replicas. No credit card required. New Free connections get seven days of full collection, then reduced sampling. Free and Pro include 30 days of monitoring history.