Very long startup after crash with no message in log - Mailing list pgsql-admin

From Ondřej Světlík
Subject Very long startup after crash with no message in log
Date
Msg-id 572B69D9.5060202@flexibee.eu
Whole thread Raw
Responses Re: Very long startup after crash with no message in log  (Jerry Sievers <gsievers19@comcast.net>)
List 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


pgsql-admin by date:

Previous
From: Ondřej Světlík
Date:
Subject: Re: Autovacuum of pg_database
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum of pg_database