Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'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>
In-Reply-To: <28454.1270071766@sss.pgh.pa.us>
Subject: Re: Statistics Collector not collecting server activities 
Date: Fri, 9 Apr 2010 19:03:28 +0530
Organization: Zoniac Software Private Limited
Message-ID: <004801cad7e9$414f7a80$c3ee6f80$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcrRGxrz6a+JnK3tTqS3fe+1fLIIoAGzZJcw
Content-Language: en-us

Hi Tom,

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.

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

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Thursday, April 01, 2010 3:13 AM
To: gnanam@zoniac.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities 

"Gnanakumar" <gnanam@zoniac.com> writes:
> I'm also seeing a weird thing.  If I do 'show stats_start_collector;'
inside
> psql, it says 'off'.

Yeah, this is the expected state if the collector fails to start for
some reason.  Look into the postmaster log for a startup-time message
indicating why; but again, I'll bet on problems creating its UDP socket.

			regards, tom lane