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@xxxxxxxxxxxxx] Sent: Thursday, April 01, 2010 3:13 AM To: gnanam@xxxxxxxxxx Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Statistics Collector not collecting server activities "Gnanakumar" <gnanam@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
