From: Gnanakumar <gnanam@zoniac.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Statistics Collector not collecting server activities
Date: Fri, 9 Apr 2010 19:03:28 +0530
Message-ID: <004801cad7e9$414f7a80$c3ee6f80$@com> (raw)
In-Reply-To: <28454.1270071766@sss.pgh.pa.us>
References: <007a01cad09d$33907af0$9ab170d0$@com>
<008b01cad0a3$a50782e0$ef1688a0$@com>
<28454.1270071766@sss.pgh.pa.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
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: gnanam@zoniac.com, tgl@sss.pgh.pa.us
Subject: Re: Statistics Collector not collecting server activities
In-Reply-To: <004801cad7e9$414f7a80$c3ee6f80$@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