Re: pg_stat_activity

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.