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/
***-*--*----*-------*------------*--------------------*---------------
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 |