Thread: Re: Concurrent Connections - User only allowed one

Re: Concurrent Connections - User only allowed one

From
"Gordon Ross"
Date:
I've double checked the code, and it gets one connection to the db
"dbCon = DriverManager.getConnection(dbURL, dbUser, dbPassword);", and
just re-uses that. Before it attempts to get a connection, it checks to
make sure it doesn't already have a connection, and that's it.

Is it possible to get PG to log connection attempts, so I can double
check ?

Thanks,

GTG

>>> Paul Thomas <paul@tmsl.demon.co.uk> 03/10/2003 13:21:09 >>>

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. Could this be the case somehow? You would

still be able to psql to the db from the Solaris box as there are
usually
a couple of reserved super-user connections. I can't explain why you
get
that particular error message though.


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

Re: Concurrent Connections - User only allowed one

From
Craig Moon
Date:
You can turn on connection logging by editing postgresql.conf and
uncommenting the line

log_connections = false

and setting it to true.

Gordon Ross wrote:

>I've double checked the code, and it gets one connection to the db
>"dbCon = DriverManager.getConnection(dbURL, dbUser, dbPassword);", and
>just re-uses that. Before it attempts to get a connection, it checks to
>make sure it doesn't already have a connection, and that's it.
>
>Is it possible to get PG to log connection attempts, so I can double
>check ?
>
>Thanks,
>
>GTG
>
>
>
>>>>Paul Thomas <paul@tmsl.demon.co.uk> 03/10/2003 13:21:09 >>>
>>>>
>>>>
>
>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. Could this be the case somehow? You would
>
>still be able to psql to the db from the Solaris box as there are
>usually
>a couple of reserved super-user connections. I can't explain why you
>get
>that particular error message though.
>
>
>
>