Re: Problems restarting after database crashed (signal 11). - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems restarting after database crashed (signal 11).
Date
Msg-id 28321.1088700575@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems restarting after database crashed (signal 11).  (Christopher Cashell <topher-pgsql@zyp.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DELETE TABLE xx do not erase index file after a vacuum full ?
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Problems restarting after database crashed (signal