Thread: Postgres Max JDBC Connection Allowed

Postgres Max JDBC Connection Allowed

From
"Sharma;G.S."
Date:
Hi,
    I am using Postgres 7.3 can any body tell me the max no of JDBC connections allowed by postgres .
    I also want to know how to find out that howmuch memory and CPU , my postgres is taking .
 
Thanks in advance        
 
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable.

Re: Postgres Max JDBC Connection Allowed

From
Chris Mair
Date:
> Hi,
>     I am using Postgres 7.3 can any body tell me the max no of JDBC
> connections allowed by postgres .

The maximum number of connections is a configuration variable in the
file postgresql.conf in your PGDATA dir.
Whether they origin from a JDBC driver or not is not relevant.

>     I also want to know how to find out that howmuch memory and CPU ,
> my postgres is taking .

Ask your operating system :)
top on unices or the tasklist on windows might be a start...

Bye, Chris.


--

Chris Mair
http://www.1006.org



Re: Postgres Max JDBC Connection Allowed

From
"Aaron Bono"
Date:
On 8/10/06, Chris Mair <chrisnospam@1006.org> wrote:

> Hi,
>     I am using Postgres 7.3 can any body tell me the max no of JDBC
> connections allowed by postgres .

The maximum number of connections is a configuration variable in the
file postgresql.conf in your PGDATA dir.
Whether they origin from a JDBC driver or not is not relevant.

>     I also want to know how to find out that howmuch memory and CPU ,
> my postgres is taking .

Ask your operating system :)
top on unices or the tasklist on windows might be a start...

 
Don't forget to check the ulimit for the postgres user.  I had problems on a couple of our servers because the default for users was to limit their memory and number of processes.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================