Log files, how to rotate properly

Поиск
Список
Период
Сортировка
Искать
От
Dave Cramer
Тема
Log files, how to rotate properly
Дата
Msg-id
0afa01c0f42d$14c9d090$0302a8c0@INSPIRON
Список
Дерево обсуждения
Re: Log files, how to rotate properly Vivek Khera <khera@kcilink.com>
Re: Re: Log files, how to rotate properly Martín Marqués <martin@bugs.unl.edu.ar>
I just ran into an interesting problem. My /var partition was full, and the
culprit turned out to be the postgres log file, which was only evident
through lsof. It was actually a deleted file which was being kept open by
the running process.

The interesting thing is that if I redirect the output of postmaster, then
every connection has this file open.

My environment is Apache/jserv/postgres. So in order to rotate the postgres
log, I would have to

1) Shut apache down,
2) Shut jserv down
3) Shut postgres down
rotate the logs, then bring them all back up again

Is there a way to tell postgres to release the log file, or am I completely
off base here?

Dave



В списке pgsql-general по дате отправления
От: Lamar Owen
Дата:
Сообщение: Re: Oracle news article
От: mazzo
Дата:
Сообщение: Problems with views
FAQ