Re: Very long startup after crash with no message in log

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Re: Very long startup after crash with no message in log
Дата
Msg-id 86oa8k4cfu.fsf@jerry.enova.com
обсуждение исходный текст
Ответ на Very long startup after crash with no message in log  (Ondřej Světlík <osvetlik@flexibee.eu>)
Список pgsql-admin
OndYej Svtlík <osvetlik@flexibee.eu> writes:

> Hello again,
>
> last night we came across another unpleasant behaviour. I managed to
> crash the cluster and the next start took really long (about 4
> hours). Even in single mode with -d1 there was no message telling us
> what's going on. We used lsof and found out that the process opens
> each database and performs some operation which takes up to a few
> seconds (with almost 6k databases). It would be really nice to tell
> the user what's going on. Or is there a configuration option which
> will enable such logging, perhaps?

Have a look at log_min_messages.

> Thank you,
>
> Ondřej

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


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

Предыдущее
От: Ondřej Světlík
Дата:
Сообщение: Re: Autovacuum of pg_database
Следующее
От: Rob Cowell
Дата:
Сообщение: Error in log file after database crash