Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 8F967633197
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 31 Mar 2010 06:05:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 85099-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 31 Mar 2010 09:04:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74])
	by mail.postgresql.org (Postfix) with ESMTP id E838A632504
	for <pgsql-admin@postgresql.org>; Wed, 31 Mar 2010 06:04:51 -0300 (ADT)
Received: from [192.168.0.7] (uni14-1-82-233-223-216.fbx.proxad.net
	[82.233.223.216])
	by sd-17937.dedibox.fr (Postfix) with ESMTPA id B7FFF3B8F5;
	Wed, 31 Mar 2010 11:04:50 +0200 (CEST)
Message-ID: <4BB31032.6060809@lelarge.info>
Date: Wed, 31 Mar 2010 11:04:50 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr;
	rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3
MIME-Version: 1.0
To: gnanam@zoniac.com
CC: pgsql-admin@postgresql.org
Subject: Re: Statistics Collector not collecting server activities
References: <007501cad09d$326fefc0$974fcf40$@com>
	<4BB2FA68.6060708@lelarge.info>
	<00b601cad0b0$5e713760$1b53a620$@com>
In-Reply-To: <00b601cad0b0$5e713760$1b53a620$@com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.232 tagged_above=-10 required=5 tests=AWL=-0.122,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201003/276
X-Sequence-Number: 34075

Le 31/03/2010 10:58, Gnanakumar a écrit :
> I’m also seeing a weird thing.  If I do ‘show stats_start_collector;’ inside
> psql, it says ‘off’.
> 
> I’ve also restarted my server many times after making all the changes.
> 
> As per 8.2 doc,
> http://www.postgresql.org/docs/8.2/interactive/runtime-config-statistics.htm
> l, stats_start_collector is on by default.
> 

If it is off (as you found with the "show stats_start_collector"
statement), you should getting ride of the # in front of the
stats_start_collector parameter. Ie, you should have

stats_start_collector = on

and not

#stats_start_collector = on

or

#stats_start_collector = off

Once you've done this, restart PostgreSQL and it should work.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com