Re: Logfile removal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Logfile removal
Дата
Msg-id 6954.1053527142@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Logfile removal  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Список pgsql-admin
"A.Bhuvaneswaran" <bhuvansql@myrealbox.com> writes:
> I have run postmaster with -l option. When postmaster is running, i have
> removed the logfile accidentally.

You mean the -l logfile (postmaster's stderr)?  This is harmless except
that you won't have any way to look at the logfile.

> I am unable to restart postmaster now due to various other reasons.

The only way to start seeing the entries again is to restart the
postmaster, so I'd counsel doing that as soon as feasible.

What's actually happened is that the logfile is still on your disk (and
growing all the time...) but there is no link left to it in your
filesystem.  The kernel knows the file is still referenced by the open
filetable entry held by the postmaster, so it won't delete the file till
the postmaster quits.  But you have no way to get at it.

            regards, tom lane

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Logfile removal
Следующее
От: Robert.Farrugia@go.com.mt
Дата:
Сообщение: After VACUUM, statistics become skewed