Index: maintenance.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/maintenance.sgml,v retrieving revision 1.33 diff -c -c -r1.33 maintenance.sgml *** maintenance.sgml 5 Apr 2004 03:02:03 -0000 1.33 --- maintenance.sgml 14 May 2004 19:57:46 -0000 *************** *** 461,467 **** you can send a SIGHUP signal to the syslog daemon whenever you want to force it to start writing a new log file. If you want to automate log ! rotation, the logrotate program can be configured to work with log files from syslog. --- 461,467 ---- you can send a SIGHUP signal to the syslog daemon whenever you want to force it to start writing a new log file. If you want to automate log ! rotation, the rotatelogs program can be configured to work with log files from syslog. *************** *** 484,495 **** pipe command: ! pg_ctl start | logrotate The PostgreSQL distribution doesn't include a suitable log rotation program, but there are many available on the ! Internet. For example, the logrotate tool included in the Apache distribution can be used with PostgreSQL. --- 484,495 ---- pipe command: ! pg_ctl start | rotatelogs /var/log/pgsql_log 86400 The PostgreSQL distribution doesn't include a suitable log rotation program, but there are many available on the ! Internet. For example, the rotatelogs tool included in the Apache distribution can be used with PostgreSQL. Index: ref/pg_ctl-ref.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/ref/pg_ctl-ref.sgml,v retrieving revision 1.25 diff -c -c -r1.25 pg_ctl-ref.sgml *** ref/pg_ctl-ref.sgml 29 Nov 2003 19:51:39 -0000 1.25 --- ref/pg_ctl-ref.sgml 14 May 2004 19:57:46 -0000 *************** *** 87,99 **** server is started in the background, and standard input is attached to /dev/null. The standard output and standard error are either appended to a log file (if the ! option is used), or redirected to pg_ctl's standard output (not standard error). If no log file is chosen, the standard output of pg_ctl should be redirected ! to a file or piped to another process, for example a log rotating program, ! otherwise postmaster will write its output to the controlling ! terminal (from the background) and will not leave the shell's ! process group. --- 87,99 ---- server is started in the background, and standard input is attached to /dev/null. The standard output and standard error are either appended to a log file (if the ! option is used), or redirected to pg_ctl's standard output (not standard error). If no log file is chosen, the standard output of pg_ctl should be redirected ! to a file or piped to another process such as a log rotating program ! like rotatelogs; otherwise the postmaster ! will write its output to the controlling terminal (from the background) ! and will not leave the shell's process group.