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

From Jerry Sievers
Subject Re: Very long startup after crash with no message in log
Date
Msg-id 86oa8k4cfu.fsf@jerry.enova.com
Whole thread Raw
In response to Very long startup after crash with no message in log  (Ondřej Světlík <osvetlik@flexibee.eu>)
List 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 by date:

Previous
From: Ondřej Světlík
Date:
Subject: Re: Autovacuum of pg_database
Next
From: Rob Cowell
Date:
Subject: Error in log file after database crash