Skip to content

Instantly share code, notes, and snippets.

@jljohnstone
Created September 29, 2017 10:31
Show Gist options
  • Save jljohnstone/d57f5f11d5c07b7cda5268df02a2a6c0 to your computer and use it in GitHub Desktop.
Save jljohnstone/d57f5f11d5c07b7cda5268df02a2a6c0 to your computer and use it in GitHub Desktop.
postgresql
# 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 peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment