Re: Concurrent Connections - User only allowed one connection

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   |
+------------------------------+---------------------------------------------+