X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 586BD9DCA8B
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:27:45 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 00675-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:27:42 -0400 (AST)
X-Greylist: delayed 00:30:59.583151 by SQLgrey-
Received: from smtp-ft5.fr.colt.net (smtp-ft5.fr.colt.net [213.41.78.199])
	by postgresql.org (Postfix) with ESMTP id C77129DCAE1
	for <pgsql-admin@postgresql.org>; Thu,  2 Feb 2006 12:27:40 -0400 (AST)
Received: from [192.168.10.52] (www.carax.com [62.23.146.23] (may be forged))
	by smtp-ft5.fr.colt.net (8.13.4/8.13.4/Debian-3) with ESMTP id
	k12GRZ7N031995; Thu, 2 Feb 2006 17:27:35 +0100
Message-ID: <43E232F6.7080105@carax.com>
Date: Thu, 02 Feb 2006 17:27:34 +0100
From: =?ISO-8859-1?Q?C=E9dric_BUSCHINI?= <cbuschini@carax.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr;
	rv:1.7.12) Gecko/20050915
X-Accept-Language: fr, en
MIME-Version: 1.0
To: Brad Nicholson <bnichols@ca.afilias.info>, pgsql-admin@postgresql.org
Subject: Re: pg_stat_activity
References: <43E22BB6.4030701@carax.com> <43E22CD7.4040909@ca.afilias.info>
In-Reply-To: <43E22CD7.4040909@ca.afilias.info>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
X-Spam-Score: 0.12
X-Spam-Level: 
X-Archive-Number: 200602/20
X-Sequence-Number: 20441

Brad Nicholson a écrit :

> Cédric BUSCHINI wrote:
>
>> Hello,
>>
>> question in 2 times :
>>
>> 1 - "select * from pg_stat_activity ;" gives me serverals lines but 
>> all lines have <command string not enable> in current_query
>> I have set "stats_command_string" to true...
>>
> Have you restarted the postmaster since making the change?  This 
> setting requires restart (reload will not work)
>
>> 2 - I wanna to log  users activity : connections, disconnection, 
>> queries, ... I assume there is a good way to do that .....
>>
> It's all in the logging section of the postgresql.conf file, clearly 
> labeled.  Most can be changed with a reload
>
> http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html 
>
>
>
My fault ....

I have not restarted it ... done and works !!
Sorry ...

Thanks for the link