This is a discussion on separate logfiles within the pgsql Admins forums, part of the PostgreSQL category; --> Hi all. I have turned on log_min_duration_statement = 0 and logging everything to syslog, LOCAL0. Is there a way ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi all. I have turned on log_min_duration_statement = 0 and logging everything to syslog, LOCAL0. Is there a way to separate the query logging from the rest ? Can I somehow have 1 logfile for the "usual" Postgres messages, and another logfile for the logging generated by setting log_min_duration_statement = 0 ? The log is growing quite fast, and even if I use logrotation it gets quite big so it's a bit tedious to find stuff in the log that is Not related to query statistics. I run 8.1 on a Debian system. Thanx /zw |