Re: Concurrent Connections - User only allowed one

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(at)tmsl(dot)demon(dot)co(dot)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