One app is connecting through libpqxx, the other 2, glassfish and ejabber chat agent, I am not certain.
It is only on this one machine where I am having a connection issue with any of these apps.
I can connect via the identical roles that these apps would be using via the psql command line on this system.
I doubt that all three would have a connection issue on the same day, without some kind of global matter.
My pg_hba.conf file on this system is the following.
# "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.
host all all 192.168.32.0/19 trust
I don’t believe this to be a postgres problem, but you don’t know what you don’t know.
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Friday, October 23, 2015 10:36 AM
To: Day, David
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] strange connection problem.
I have a development site ( FreeBSD 10.1 and Postgres 9.3 ) where I can connect to the database via psql or pgadminIII both locally and remotely.
However, all of the local apps ( 3 different ones ) that would connect to it are failing to connect.
So how do the methods the local apps use to connect to PostgreSQL differ compared to running psql directly on the same machine?
