Обсуждение: pg_stat_activity
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
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.
Brad Nicholson <bnichols@ca.afilias.info> writes:
> C�dric BUSCHINI wrote:
>> 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)
stats_start_collector requires that, but the other stats settings can
be changed on the fly...
regards, tom lane
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