Re: maximum java process postgres connections

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(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Stephen Ingram
> Sent: Thursday, March 14, 2002 4:44 PM
> To: Dave(at)micro-automation(dot)net; pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Stephen Ingram
> > Sent: Wednesday, March 13, 2002 10:32 PM
> > To: pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>