Skip to content

Instantly share code, notes, and snippets.

@deckerego
Created December 6, 2013 17:13
Show Gist options
  • Save deckerego/7828533 to your computer and use it in GitHub Desktop.
Save deckerego/7828533 to your computer and use it in GitHub Desktop.
PostgreSQL is set up for local authentication by default, so there has to be some minor tomfoolery to get it to accept JDBC connections that don't rely on host-based authentication. Modify /var/lib/pgsql/data/pg_hba.conf to look similar to the following.
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment