SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:46 AM
| ||||
| ||||
 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-10-2008, 05:46 AM
| |||
| |||
| 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/i...g-logging.html -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-10-2008, 05:46 AM
| |||
| |||
| Re: pg_stat_activity 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-10-2008, 05:46 AM
| ||||
| ||||
| Re: pg_stat_activity 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/i...g-logging.html > > > My fault .... I have not restarted it ... done and works !! Sorry ... Thanks for the link ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
Linear Mode
