Re: strange connection problem.

From: "Day, David" <dday(at)redcom(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: strange connection problem.
Date: 2015-10-23 15:23:21
Message-ID: 401084E5E73F4241A44F3C9E6FD79428011C3FA4B3@exch-01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Friday, October 23, 2015 10:36 AM
To: Day, David
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] strange connection problem.

On Fri, Oct 23, 2015 at 10:29 AM, Day, David <dday(at)redcom(dot)com<mailto:dday(at)redcom(dot)com>> wrote:
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?

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-10-23 16:05:59 Re: A question about PL/pgSQL DECLAREd variable behavior
Previous Message Melvin Davidson 2015-10-23 14:52:01 Re: clone_schema function