Thread: How to restart postmaster after a violent shutdown ?

How to restart postmaster after a violent shutdown ?

From
Gaetan GUYODO
Date:
Hi,
a few minutes ago, an electric fail... my computer had a violent shutdown !
when the electricity came back, I started my computer, and had no problem
(Linux SuSe 7.2 with ReiserFS partitions).
But the postmaster, who start automatically at startup, didn't !
Is there something special to do ?
I'm not sure, but I think Postgres and the postmaster were working, when the
electric-cut happends... updating datum.

What must I do, just restart postmaster, or clean some files, or do something
else ?

Gaetan

Re: How to restart postmaster after a violent shutdown ?

From
Helge Bahmann
Date:
On Wed, 1 Aug 2001, Gaetan GUYODO wrote:
> Hi,
> a few minutes ago, an electric fail... my computer had a violent shutdown !
[...]
> What must I do, just restart postmaster, or clean some files, or do something
> else ?

Manually remove the socket /tmp/.s.PGSQL.5432 and postmaster should start
again

regards,
Helge


Re: How to restart postmaster after a violent shutdown ?

From
Tom Lane
Date:
Helge Bahmann <bahmann@math.tu-freiberg.de> writes:
> On Wed, 1 Aug 2001, Gaetan GUYODO wrote:
>> a few minutes ago, an electric fail... my computer had a violent shutdown !
> [...]
>> What must I do, just restart postmaster, or clean some files, or do something
>> else ?

> Manually remove the socket /tmp/.s.PGSQL.5432 and postmaster should start
> again

If that fixes it, next consider updating to a more recent version of
Postgres.  I know 7.1 can figure out for itself to remove an old socket
file; don't recall about 7.0.  7.1 should be more stable in the face of
power losses anyway, because of its use of WAL.

            regards, tom lane