Logfile Maintenance in PostgreSQL
Logfile Maintenance in PostgreSQL
- Save the database server's log output somewhere,
- Need to "rotate" the log files so that new log files are started and old ones removed after a reasonable period of time.
- Only way to truncate the log file is to stop and restart the server.
- Better approach is to send the server's stderr output to some type of log rotation program. There is a built-in log rotation program, which you can use by setting the configuration parameter logging_collector to true in postgresql.conf
- To managing log output is to send it all to syslog and let syslog deal with file rotation. To do this, set the configuration parameter log_destination to syslog (to log to syslog only) in postgresql.conf
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment