Re: How to restart postmaster after a violent shutdown ? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to restart postmaster after a violent shutdown ?
Date
Msg-id 9429.996675601@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to restart postmaster after a violent shutdown ?  (Helge Bahmann <bahmann@math.tu-freiberg.de>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating DB
Next
From: "Phillip J. Allen"
Date:
Subject: Managing a pgsql backend on both a Linux & WinNT workstation with a MSAccess Frontend?