From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
---|---|
To: | Cédric BUSCHINI <cbuschini(at)carax(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_stat_activity |
Date: | 2006-02-02 16:01:27 |
Message-ID: | 43E22CD7.4040909@ca.afilias.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-02-02 16:10:19 | Re: Postmaster errors |
Previous Message | mcelroy, tim | 2006-02-02 15:58:52 | Postmaster errors |