From: Andrew Sullivan <ajs@commandprompt.com>
To: pgsql-admin@postgresql.org
Subject: Re: Very Urgent : Db processes are increasing
Date: Thu, 17 Jul 2008 09:38:49 -0400
Message-ID: <20080717133849.GK6732@commandprompt.com> (raw)
In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0E7891CA@ZENMAILHQ1.ind.zensar.com>
References: <3D5445983859B84B92669C0D883EA6FB0E7891CA@ZENMAILHQ1.ind.zensar.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ajs@commandprompt.com
Subject: Re: Very Urgent : Db processes are increasing
In-Reply-To: <20080717133849.GK6732@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox