Thread: maximum java process postgres connections

maximum java process postgres connections

From
Stephen Ingram
Date:
Hi there,

I was wondering if anyone out in jdbc-land knew
how many connections one java process can have to
postgres?

steve

Re: maximum java process postgres connections

From
"Dave Cramer"
Date:
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



Re: maximum java process postgres connections

From
Stephen Ingram
Date:
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

Re: maximum java process postgres connections

From
"Dave Cramer"
Date:
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



Re: maximum java process postgres connections

From
"Nick Fankhauser"
Date:
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
>