From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)de> |
Cc: | Gaetan GUYODO <gaetan(dot)guyodo(at)lrb(dot)ap-hop-paris(dot)fr>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to restart postmaster after a violent shutdown ? |
Date: | 2001-08-01 14:20:01 |
Message-ID: | 9429.996675601@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Helge Bahmann <bahmann(at)math(dot)tu-freiberg(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip J. Allen | 2001-08-02 14:01:03 | Managing a pgsql backend on both a Linux & WinNT workstation with a MSAccess Frontend? |
Previous Message | Tom Lane | 2001-08-01 14:13:42 | Re: Creating DB |