Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'Kevin Grittner'" <Kevin.Grittner@wicourts.gov>,
	"'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: <pgsql-admin@postgresql.org>
References: <007a01cad09d$33907af0$9ab170d0$@com>
	<008b01cad0a3$a50782e0$ef1688a0$@com>
	<28454.1270071766@sss.pgh.pa.us>
	<004801cad7e9$414f7a80$c3ee6f80$@com>
	<4BBEEDF90200002500030638@gw.wicourts.gov>
In-Reply-To: <4BBEEDF90200002500030638@gw.wicourts.gov>
Subject: Re: Statistics Collector not collecting server	 activities
Date: Sat, 10 Apr 2010 11:54:56 +0530
Organization: Zoniac Software Private Limited
Message-ID: <000a01cad876$8c4bd140$a4e373c0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcrX7dL1HBCanq09TfC5IJ8PQ4hFXgAh40fg
Content-Language: en-us

Hi Kevin,

No, it is not SE-Linux and no anti-virus programs are running.  I can again
cross-check whether any firewall is enabled.

But again if postgresql service can start without any issues, why not stats
collector process the same way?

Does stats collector process need any other special
resource/privilege/operations/port to start?   Can you let me know in this
aspect, so that it would be helpful to  troubleshoot better.

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] 
Sent: Friday, April 09, 2010 7:36 PM
To: 'Tom Lane'; gnanam@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities

"Gnanakumar" <gnanam@zoniac.com> wrote:
 
> As you said, I notice the following in postmaster log:
> 2010-04-08 17:30:41 ISTLOG:  could not receive test message on
> socket for statistics collector: Connection refused
> 2010-04-08 17:30:41 ISTLOG:  disabling statistics collector for
> lack of working socket
> 
> What is going wrong?  I couldn't understand from the above lines.
 
Is an OS firewall or anti-virus program running on this machine?
Any other unusual security features, like SE-Linux?
 
-Kevin