From: | Cédric BUSCHINI <cbuschini(at)carax(dot)com> |
---|---|
To: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_stat_activity |
Date: | 2006-02-02 16:27:34 |
Message-ID: | 43E232F6.7080105@carax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Ashcraft | 2006-02-02 17:11:39 | strange hung processes |
Previous Message | Tom Lane | 2006-02-02 16:19:16 | Re: pg_stat_activity |