| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Gordon Ross <G(dot)Ross(at)ccw(dot)gov(dot)uk> |
| Cc: | "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Concurrent Connections - User only allowed one connection |
| Date: | 2003-10-03 10:19:55 |
| Message-ID: | 20031003111955.A27012@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Thomas | 2003-10-03 10:22:39 | Re: / /OREF:CPTEC539 JDBC driver source code |
| Previous Message | aribic | 2003-10-03 08:37:39 | / /OREF:CPTEC539 JDBC driver source code |