From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Statistics Collector not collecting server activities |
Date: | 2010-04-09 13:33:28 |
Message-ID: | 004801cad7e9$414f7a80$c3ee6f80$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, April 01, 2010 3:13 AM
To: gnanam(at)zoniac(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Statistics Collector not collecting server activities
"Gnanakumar" <gnanam(at)zoniac(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-04-09 14:06:01 | Re: Statistics Collector not collecting server activities |
Previous Message | Ray Stell | 2010-04-09 12:47:55 | Re: WARM standby with pg_standby |