Skip to content

Instantly share code, notes, and snippets.

@mahcloud

mahcloud/pg_hba.conf

Created January 25, 2016 18:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mahcloud/c4ead5aaff34dd60d68e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mahcloud/c4ead5aaff34dd60d68e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_hba.conf
# allow postgres user to use "ident" authentication on Unix sockets
# (as per recent comments, omit "sameuser" if on postgres 8.4 or later)
local all postgres ident sameuser
# allow all other users to use "md5" authentication on Unix sockets
local all all md5
# for users connected via local IPv4 or IPv6 connections, always require md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment