Обсуждение: Concurrent Connections - User only allowed one connection
(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) ? Thanks, GTG Gordon Ross, Network Manager/Rheolwr Rhydwaith Countryside Council for Wales/Cyngor Cefn Gwlad Cymru
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 | +------------------------------+---------------------------------------------+
I'm guessing pilot error here, can you show us the relevant code? dave On Fri, 2003-10-03 at 03: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) ? > > Thanks, > > GTG > > Gordon Ross, > Network Manager/Rheolwr Rhydwaith > Countryside Council for Wales/Cyngor Cefn Gwlad Cymru > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- Dave Cramer <Dave@micro-automation.net>