Restart after poweroutage

From: Jon Lapham <lapham(at)jandr(dot)org>
To: pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Restart after poweroutage
Date: 2007-03-13 18:08:22
Message-ID: 45F6E896.10707@jandr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Today I had a power outage which upon reboot seems to have done
something to cause Postgresql to not restart properly. This has
happened to me before:
http://archives.postgresql.org/pgsql-general/2006-09/msg00938.php

...and during this previous discussion, Tom Lane pointed out that I may
have destroyed the evidence on what was causing this problem:
http://archives.postgresql.org/pgsql-general/2006-09/msg00944.php

So, today, I have taken care to *not* destroy any evidence (ie: I didn't
delete the postmaster.pid file and restart).

What can I do to help diagnose what is happening?

Thanks!
-Jon

[root(at)bilbo ~]# rpm -q postgresql
postgresql-8.1.8-1.fc6.x86_64
[root(at)bilbo ~]# cat /etc/issue
Fedora Core release 6 (Zod)
Kernel \r on an \m
[root(at)bilbo ~]# cat /var/lib/pgsql/data/postmaster.pid
2809
/var/lib/pgsql/data
5432001 32768
[root(at)bilbo ~]# ps -Al | grep 2809
[root(at)bilbo ~]# ps -Al | grep -i post
[root(at)bilbo ~]# chkconfig --list postgresql
postgresql 0:off 1:off 2:off 3:on 4:off 5:on 6:off
[root(at)bilbo ~]# service postgresql status
postmaster is stopped
[root(at)bilbo ~]# service postgresql start
Starting postgresql service: [FAILED]
[root(at)bilbo ~]# tail -2 /var/lib/pgsql/pgstartup.log
FATAL: pre-existing shared memory block (key 5432001, ID 32768) is
still in use
HINT: If you're sure there are no old server processes still running,
remove the shared memory block with the command "ipcclean", "ipcrm", or
just delete the file "postmaster.pid".

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-13 18:38:33 Re: Restart after poweroutage
Previous Message David Legault 2007-03-13 17:57:39 Re: Stored procedure