|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.103 2010/04/16 02:22:33 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.104 2010/05/26 23:29:45 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="maintenance"> |
4 | 4 | <title>Routine Database Maintenance Tasks</title> |
@@ -821,5 +821,14 @@ pg_ctl start | rotatelogs /var/log/pgsql_log 86400 |
821 | 821 | is to configure the rotation program so that old log files are overwritten |
822 | 822 | cyclically. |
823 | 823 | </para> |
| 824 | + |
| 825 | + <para> |
| 826 | + <ulink url="http://pgfouine.projects.postgresql.org/">pgFouine</ulink> |
| 827 | + is an external project that does sophisticated log file analysis. |
| 828 | + <ulink |
| 829 | + href="http://bucardo.org/wiki/Check_postgres">check_postgres</ulink> |
| 830 | + provides Nagios alerts when important messages appear in the log |
| 831 | + files, as well as detection of many other extraordinary conditions. |
| 832 | + </para> |
824 | 833 | </sect1> |
825 | 834 | </chapter> |