| 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: | Whole Thread | Raw Message | 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 |