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 234A29DC8D2
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 11:56:41 -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 94291-08
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 11:56:45 -0400 (AST)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 828AD9DC817
	for <pgsql-admin@postgresql.org>; Thu,  2 Feb 2006 11:56:38 -0400 (AST)
Received: from smtp-ft5.fr.colt.net (smtp-ft5.fr.colt.net [213.41.78.199])
	by svr4.postgresql.org (Postfix) with ESMTP id 164C05AF0A4
	for <pgsql-admin@postgresql.org>; Thu,  2 Feb 2006 15:56:43 +0000 (GMT)
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
	k12Fud09019388
	for <pgsql-admin@postgresql.org>; Thu, 2 Feb 2006 16:56:39 +0100
Message-ID: <43E22BB6.4030701@carax.com>
Date: Thu, 02 Feb 2006 16:56:38 +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: pgsql-admin@postgresql.org
Subject: pg_stat_activity
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/15
X-Sequence-Number: 20436

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...

2 - I wanna to log  users activity : connections, disconnection, 
queries, ... I assume there is a good way to do that .....

Thanks a lot

cédric