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