Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way of logging of user queries in Postgresql than writing logs on the server side? A proxy or something like that.

Pgbouncer don't logging queries, tsung-recorder log them into xml without timestamps and user information.

share|improve this question
    
Have a look at the pg_stat_statements module: postgresql.org/docs/current/static/pgstatstatements.html –  a_horse_with_no_name Oct 4 '13 at 7:18
    
Do you mean an other way? If yes, why do you need it outside the server? –  dezso Oct 4 '13 at 7:56
    
Because on the server side logs take up too much disk space (about 0.5 Gb per minute). –  bhavenger Oct 7 '13 at 9:54
    
And I need logging only users from office for some security reasons, not apps from server. –  bhavenger Oct 7 '13 at 9:56
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.