From: | "Gordon Ross" <G(dot)Ross(at)ccw(dot)gov(dot)uk> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Concurrent Connections - User only allowed one |
Date: | 2003-10-03 12:30:16 |
Message-ID: | sf7d6be6.082@groupwise.ccw.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)tmsl(dot)demon(dot)co(dot)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 |
+------------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Waldomiro | 2003-10-03 13:23:11 | Row Lock |
Previous Message | Paul Thomas | 2003-10-03 12:21:09 | Re: Concurrent Connections - User only allowed one |