Re: Database logging.... Recycle server logs ???

Поиск
Список
Период
Сортировка
От codeWarrior
Тема Re: Database logging.... Recycle server logs ???
Дата
Msg-id avvbbi$i61$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Database logging.... Recycle server logs ???  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:4864.1042488639@sss.pgh.pa.us...
> "codeWarrior" <GPatnude@adelphia.net> writes:
> > I noticed that the server generated logfile gets real big real fast --
(15
> > queries and it's already at 1.5MB) -- Is there a switch / option to
recycle
> > the server logs periodically ???
>
> The recommended procedure is not to use pg_ctl's -l switch, but to pipe
> output from it into a log-rotating script.  The rotatelogs script from
> the Apache distribution works well, or you can roll your own.  See
>
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/logfile-maintena
nce.html
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Thanks Tom -- Of course -- I located that section of the manual immediately
after my post...  I will use logrotate....



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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: deadlock problem in Ad serving..
Следующее
От: Andrew Biagioni
Дата:
Сообщение: Deadlock Checker doesn't see foreign-key locks