Thread: maximum java process postgres connections
Hi there, I was wondering if anyone out in jdbc-land knew how many connections one java process can have to postgres? steve
As many as the backend will allow Dave -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Stephen Ingram Sent: Wednesday, March 13, 2002 10:32 PM To: pgsql-jdbc@postgresql.org Subject: [JDBC] maximum java process postgres connections Hi there, I was wondering if anyone out in jdbc-land knew how many connections one java process can have to postgres? steve ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
On Wednesday 13 March 2002 10:59 pm, Dave Cramer wrote: > As many as the backend will allow > > Dave > Hi Dave, Sorry for the delay. Thanks for the prompt response. I got an error before (which of course I have subsequently lost) but I'll try and repeat it. If I manage that, do you mind having a look at it and trying to see what it means? cheers steve > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Stephen Ingram > Sent: Wednesday, March 13, 2002 10:32 PM > To: pgsql-jdbc@postgresql.org > Subject: [JDBC] maximum java process postgres connections > > > > Hi there, > > I was wondering if anyone out in jdbc-land knew > how many connections one java process can have to > postgres? > > steve > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Steve, Sure send it along, it is likely that your backend doesn't have enough available connections Dave -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Stephen Ingram Sent: Thursday, March 14, 2002 4:44 PM To: Dave@micro-automation.net; pgsql-jdbc@postgresql.org Subject: Re: [JDBC] maximum java process postgres connections On Wednesday 13 March 2002 10:59 pm, Dave Cramer wrote: > As many as the backend will allow > > Dave > Hi Dave, Sorry for the delay. Thanks for the prompt response. I got an error before (which of course I have subsequently lost) but I'll try and repeat it. If I manage that, do you mind having a look at it and trying to see what it means? cheers steve > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Stephen Ingram > Sent: Wednesday, March 13, 2002 10:32 PM > To: pgsql-jdbc@postgresql.org > Subject: [JDBC] maximum java process postgres connections > > > > Hi there, > > I was wondering if anyone out in jdbc-land knew > how many connections one java process can have to > postgres? > > steve > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Steve- As Dave said, it sounds like you're running into a back-end limitation, so in your attempts to reproduce the problem, you may want to try actions that would load the database with more connection requests. If you are running a web application it is very easy to hit this limit when you aren't using a connection pool, since you'll be opening a connection for every browser session if there isn't a method to share them. -NickF > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Stephen Ingram > Sent: Thursday, March 14, 2002 4:44 PM > To: Dave@micro-automation.net; pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] maximum java process postgres connections > > > On Wednesday 13 March 2002 10:59 pm, Dave Cramer wrote: > > As many as the backend will allow > > > > Dave > > > > Hi Dave, > > Sorry for the delay. Thanks for the prompt response. > > I got an error before (which of course I have subsequently lost) > but I'll try and repeat it. > > If I manage that, do you mind having a look at it and > trying to see what it means? > > cheers > > steve > > > > -----Original Message----- > > From: pgsql-jdbc-owner@postgresql.org > > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Stephen Ingram > > Sent: Wednesday, March 13, 2002 10:32 PM > > To: pgsql-jdbc@postgresql.org > > Subject: [JDBC] maximum java process postgres connections > > > > > > > > Hi there, > > > > I was wondering if anyone out in jdbc-land knew > > how many connections one java process can have to > > postgres? > > > > steve > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >