Created
February 26, 2019 14:54
-
-
Save thebinarypenguin/a9989464627684c5b2595407dea49916 to your computer and use it in GitHub Desktop.
Postgres host based authentication, trust local
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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