Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save thebinarypenguin/a9989464627684c5b2595407dea49916 to your computer and use it in GitHub Desktop.
Save thebinarypenguin/a9989464627684c5b2595407dea49916 to your computer and use it in GitHub Desktop.
Postgres host based authentication, trust local
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment