Re: Postgres has stopped logging

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres has stopped logging
Дата
Msg-id 6353.1244221011@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres has stopped logging  (Lewis Kapell <lkapell@setonhome.org>)
Ответы Re: Postgres has stopped logging  (Lewis Kapell <lkapell@setonhome.org>)
Список pgsql-admin
Lewis Kapell <lkapell@setonhome.org> writes:
> If I search the output of ps -ax for entries containing both "postgres:"
> and "process" I get the following:

>   2259 ?        Ss     0:03 postgres: logger process

Well, that looks reasonable.  You might try strace'ing that process
while you do something that's certain to provoke a log entry
(maybe "SELECT 1/0;" in a psql session).

The only likely problem that I can think of at this point is that
SELinux might think the process shouldn't be allowed to write in
/var/log/postgres/, but I don't know why that would have just suddenly
started to be a problem after working before.  Unless maybe someone
did a system-wide restorecon or some such.

            regards, tom lane

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

Предыдущее
От: Lewis Kapell
Дата:
Сообщение: Re: Postgres has stopped logging
Следующее
От: "Atul Chojar"
Дата:
Сообщение: How to automatically propagate new/changed database functions from one database to another