Re: restarting after power outage - Mailing list pgsql-general

From Tom Lane
Subject Re: restarting after power outage
Date
Msg-id 24884.1114626382@sss.pgh.pa.us
Whole thread Raw
In response to restarting after power outage  (Jon Lapham <lapham@jandr.org>)
Responses Re: restarting after power outage  (Jon Lapham <lapham@jandr.org>)
List pgsql-general
Jon Lapham <lapham@jandr.org> writes:
> After a power outage (and bad UPS combo, or plug pull, or bad RAM, etc)
> sometimes (I would guess <10% of the time) postgresql fails to restart
> automatically after booting the computer.  Invariably, it is because the
> "postmaster.pid" file exists, but maybe this is just a symptom of
> something else.  The solution I have been performing is to simply delete
> this file, and then restart postgres (service postgresql start).

> Is this the correct procedure?

It is.  We have been fooling with the postmaster startup logic to try to
eliminate this gotcha, but it's only very recently (8.0.2) that I think
we got it right.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: populating a table via the COPY command using C code.
Next
From: "John Liu"
Date:
Subject: dump and restore a single table containing large objects