Re: 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(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

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

Steve,

Sure send it along, it is likely that your backend doesn't have enough
available connections

Dave

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

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
>