Very Urgent : Db processes are increasing

From: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Very Urgent : Db processes are increasing
Date: 2008-07-17 09:16:58
Message-ID: 3D5445983859B84B92669C0D883EA6FB0E7891CA@ZENMAILHQ1.ind.zensar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List,

I am using pgsql 7.4.2 on solaris-9. When I start the postgres with "-i"
option as below, the processes of the postgres are increasing
drastically.

pg_ctl start -D /db1/postgresql/data -o "-i"

If I exclude "-I" option, my application couldn't connect the DB server
at all.
Here are my queries.
1) Why DB processes are increasing drastically, it reaches up to 104
connection( configured to 100 max connections) through there is no
application trying to connect/access the DB.

2) Is "-I" option is important to get the access from other server to DB
server ??

Pls reply your quick response.

--Suresh

DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2008-07-17 09:51:47 Re: log_statement at postgres.conf
Previous Message System/IJS - Joko 2008-07-17 08:43:28 log_statement at postgres.conf