Log files, how to rotate properly
От | Dave Cramer |
---|---|
Тема | Log files, how to rotate properly |
Дата | |
Msg-id | 0afa01c0f42d$14c9d090$0302a8c0@INSPIRON обсуждение исходный текст |
Ответ на | Re: 7.1.2 temporary file area (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Log files, how to rotate properly
Re: Log files, how to rotate properly |
Список | pgsql-general |
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 по дате отправления: