Обсуждение: Re: Concurrent Connections - User only allowed one
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 | +------------------------------+---------------------------------------------+
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. > > > >