Re: pg_stat_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux