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 660B09DC82D
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:01:34 -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 93643-10
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 12:01:30 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62])
	by postgresql.org (Postfix) with ESMTP id B61119DC817
	for <pgsql-admin@postgresql.org>; Thu,  2 Feb 2006 12:01:29 -0400 (AST)
Received: from dba5.int.libertyrms.com ([10.1.3.44])
	by mail.libertyrms.com with esmtp (Exim 4.22)
	id 1F4gtj-0001yo-Te; Thu, 02 Feb 2006 11:01:27 -0500
Message-ID: <43E22CD7.4040909@ca.afilias.info>
Date: Thu, 02 Feb 2006 11:01:27 -0500
From: Brad Nicholson <bnichols@ca.afilias.info>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: =?ISO-8859-1?Q?C=E9dric_BUSCHINI?= <cbuschini@carax.com>
CC: pgsql-admin@postgresql.org
Subject: Re: pg_stat_activity
References: <43E22BB6.4030701@carax.com>
In-Reply-To: <43E22BB6.4030701@carax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-SA-Exim-Mail-From: bnichols@ca.afilias.info
X-SA-Exim-Scanned: No; SAEximRunCond expanded to false
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.253 required=5 tests=[AWL=0.253]
X-Spam-Score: 0.253
X-Spam-Level: 
X-Archive-Number: 200602/17
X-Sequence-Number: 20438

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


-- 
Brad Nicholson  416-673-4106   
Database Administrator, Afilias Canada Corp.