Very long startup after crash with no message in log

From: Ondřej Světlík <osvetlik(at)flexibee(dot)eu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Very long startup after crash with no message in log
Date: 2016-05-05 15:42:17
Message-ID: 572B69D9.5060202@flexibee.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Thank you,

Ondřej

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2016-05-05 15:43:41 Re: Autovacuum of pg_database
Previous Message Ondřej Světlík 2016-05-05 15:35:58 Re: Autovacuum of pg_database