#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.
# CAUTION: Configuring the system for local "trust" authentication
# allows any local user to connect as any PostgreSQL user, including
# the database superuser. If you do not trust all your local users,
# use another authentication method.
and from postgresql.conf
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
On Nov 12, 2013, at 4:19 PM, Ramsey Gurley <
email@hidden> wrote:
Is the db on the same machine as the app? If not, this won’t work. You need to add the IP of your app server. Something like...
host all all 192.168.0.100 trust
On Nov 12, 2013, at 1:41 PM, Joe Kramer <
email@hidden> wrote:
Thanks for the reply. Here is my config in pg_hba.conf. It seems like this should not be causing the issue. Any other thoughts or something I am missing in this config?
Thanks,
Joe
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
# IPv6 local connections:
host all all ::1/128 trust