Date: Thu, 17 Jul 2008 09:38:49 -0400
From: Andrew Sullivan <ajs@commandprompt.com>
To: pgsql-admin@postgresql.org
Subject: Re: Very Urgent : Db processes are increasing
Message-ID: <20080717133849.GK6732@commandprompt.com>
Mail-Followup-To: Andrew Sullivan <ajs@commandprompt.com>,
	pgsql-admin@postgresql.org
References: 
 <3D5445983859B84B92669C0D883EA6FB0E7891CA@ZENMAILHQ1.ind.zensar.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <3D5445983859B84B92669C0D883EA6FB0E7891CA@ZENMAILHQ1.ind.zensar.com>
User-Agent: Mutt/1.5.17 (2007-11-01)

On Thu, Jul 17, 2008 at 02:46:58PM +0530, Suresh Gupta VG wrote:
> Hi List,
> 
> I am using pgsql 7.4.2 on solaris-9. 

Go and upgrade that right away.  It has several very nasty bugs in
it.  7.4.21 is the latest.

> pg_ctl start -D /db1/postgresql/data -o "-i"
> 
> If I exclude "-I" option, my application couldn't connect the DB server
> at all. 

Well, you could set that in the configuration file, but obviously,
you're using the network somehow.

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

Something is connecting.  You can change the logging settings to find
out who is connecting and from where.  Alternatively, try netstat to
look at who is connecting to port 5432.
 
> 2) Is "-I" option is important to get the access from other server to DB
> server ??

Well, it's spelled "-i", but yes.  You have to listen on a TCP/IP
socket, or else nobody can connect from another server.

A

-- 
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/