Re: Postgres has stopped logging

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres has stopped logging
Дата
Msg-id 5287.1244217760@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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:
> This is a really strange one.  We are running PostgreSQL 8.3.7 on a
> Fedora Core 8 system (uname -a gives: 2.6.23.1-42.fc8).

> On Wednesday I was reading about the upcoming change in the default
> value of default_statistics_target from 10 to 100 - we had never changed
> this value, so I bumped it up a bit and also changed the value of
> log_autovacuum_min_duration so that I could monitor the results.
> Yesterday I tweaked the settings a bit more and continued to monitor the
> logs.  About two hours later, the log file stopped growing.

Are you watching the right log file?  I believe most Fedora packagings
of PG are set up to rotate log output among multiple files.  In any
case it's hard to diagnose this without knowing what logging settings
you're using.

            regards, tom lane

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

Предыдущее
От: Lewis Kapell
Дата:
Сообщение: Re: Postgres has stopped logging
Следующее
От: Lewis Kapell
Дата:
Сообщение: Re: Postgres has stopped logging