Re: Concurrent Connections - User only allowed one - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Concurrent Connections - User only allowed one
Date
Msg-id 19172.1065191087@sss.pgh.pa.us
Whole thread Raw
In response to Re: Concurrent Connections - User only allowed one  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-jdbc
Paul Thomas <paul@tmsl.demon.co.uk> writes:
> On 03/10/2003 11:35 Gordon Ross wrote:
>> OK. I increased it from the default of 32 to 128 and did a pg_ctl
>> reload. Still get the same problem. With server running (but doing
>> nothing), cannot connect from PC, I get the error message: "No
>> pg_hba.conf entry for host 192.168.24.108" - yet shutting down the
>> server process allows the PC to connect.

> Wierd. It sounds like your server program is grabbing every possible
> tcp/ip connection to the db.

I don't think that's the issue at all --- if it were an
out-of-connections situation, that error message would not be what comes
up.  But I cannot think how the presence of one connection would affect
the ability of another to match a pg_hba.conf entry.  What do you have
in pg_hba.conf, anyway??  Does the complaint message actually match your
PC's address?  (And let's see the entire error message, please, not an
edited subset.  Looking in the postmaster log to see if more is reported
there would be helpful too.)

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Craig Moon
Date:
Subject: Re: Concurrent Connections - User only allowed one
Next
From: Dave Cramer
Date:
Subject: Re: Concurrent Connections - User only allowed one