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

From Gordon Ross
Subject Re: Concurrent Connections - User only allowed one
Date
Msg-id sf7d50f4.008@groupwise.ccw.gov.uk
Whole thread Raw
Responses Re: Concurrent Connections - User only allowed one
Re: Concurrent Connections - User only allowed one
List pgsql-jdbc
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.

GTG

>>> Paul Thomas <paul@tmsl.demon.co.uk> 03/10/2003 11:19:55 >>>

On 03/10/2003 08:43 Gordon Ross wrote:
> (Running PG 7.3.4 on Sparc Solaris 9)
>
> I have a Java application (which connects to Postgres using JDBC)
which
> I run from the Solaris box, but which I develop from my desktop PC.
When
> my application connects to Postgres, it can only obtain one
connection.
> i.e. if the server app is running, then my PC cannot connect, but if
my
> PC version is running, then the server cannot connect.
>
> If the server app is running, then I cannot connect with other tools
> from my PC (e.g. EMS Postgres manager), but I can always connect
using
> psql from the Solaris command line.
>
> Is this a bug, feature or just good old human error (on my part) ?

It soulds like you need to increase max_connections in
postgresql.conf.

HTH

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

---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

pgsql-jdbc by date:

Previous
From: Paul Thomas
Date:
Subject: Re: / /OREF:CPTEC539 JDBC driver source code
Next
From: Paul Thomas
Date:
Subject: Re: Concurrent Connections - User only allowed one