rotating log files

Поиск
Список
Период
Сортировка
От Jelle Ouwerkerk
Тема rotating log files
Дата
Msg-id Pine.NEB.4.10.10104270915001.24443-100000@what.openface.ca
обсуждение исходный текст
Ответы Re: rotating log files  (Peter Eisentraut <peter_e@gmx.net>)
Test Message (No Reply Necessary)  ("Roderick A. Anderson" <raanders@tincan.org>)
Список pgsql-general
Hi

What is a good solution for rotating postgresql log files?

I'm running 'Linux 2.2.16-22smp #1 SMP i686 unknown' and a solution that
was proposed to me was to use cron and a program called logrotate:

DESCRIPTION
       logrotate is designed to ease  administration  of  systems
       that generate large numbers of log files.  It allows auto­
       matic rotation, compression, removal, and mailing  of  log
       files.   Each  log  file  may  be  handled  daily, weekly,
       monthly, or when it grows too large.

Unfortunately, after replacing/rotating/compressing the database log file,
the new log file remains empty. I have a feeling that postgres has lost
the reference to the original log file and that the new log data is lost
into the void.

I'm curious what the consensus is about managing log files.

Thanks

Jelle Ouwerkerk
Software Developer
Openface Internet Inc.
Montreal, Quebec, Canada
http://www.openface.ca


В списке pgsql-general по дате отправления:

Предыдущее
От: Sterling
Дата:
Сообщение: SQL Where Like - Range it?!
Следующее
От: Stefan Karrmann
Дата:
Сообщение: starting personal postmaster