Re: Problems restarting after database crashed (signal 11).

Christopher Cashell <topher-pgsql@zyp.org> writes:
>       [2004-06-30 08:44:53 AM] Failed connection to database template1
>       with error: FATAL:  the database system is starting up
>       .
>       [2004-06-30 08:44:53 AM] Failed connection to database template1
>       with error: FATAL:  the database system is starting up
>       .
>       [2004-06-30 08:44:53 AM] Error: Cannot connect to template1,
>       exiting.

>       So, I shut down Postgres, then restarted Postgres, then restarted
>       the autovacuum utility, and everything worked just peachy.  I'm
>       guessing that perhaps the autovacuum tool was trying to connect to
>       Postgres while it was replaying the transaction log from not
>       having been shut down cleanly, and that's why it choked, but I
>       don't know that for sure.

Yeah, that's what it looks like to me --- autovacuum just a bit too
quick to give up.  You could've just restarted autovacuum once the
database was up.

In 7.5 I think autovacuum will be integrated, and the postmaster won't
bother to start it till the startup sequence is done, so this won't
be an issue.

            regards, tom lane