Restart after poweroutage
| От | Jon Lapham |
|---|---|
| Тема | Restart after poweroutage |
| Дата | |
| Msg-id | 45F6E896.10707@jandr.org обсуждение исходный текст |
| Ответы |
Re: Restart after poweroutage
Re: Restart after poweroutage |
| Список | 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@bilbo ~]# rpm -q postgresql postgresql-8.1.8-1.fc6.x86_64 [root@bilbo ~]# cat /etc/issue Fedora Core release 6 (Zod) Kernel \r on an \m [root@bilbo ~]# cat /var/lib/pgsql/data/postmaster.pid 2809 /var/lib/pgsql/data 5432001 32768 [root@bilbo ~]# ps -Al | grep 2809 [root@bilbo ~]# ps -Al | grep -i post [root@bilbo ~]# chkconfig --list postgresql postgresql 0:off 1:off 2:off 3:on 4:off 5:on 6:off [root@bilbo ~]# service postgresql status postmaster is stopped [root@bilbo ~]# service postgresql start Starting postgresql service: [FAILED] [root@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@jandr.org> Rio de Janeiro, Brasil Personal: http://www.jandr.org/ ***-*--*----*-------*------------*--------------------*---------------
В списке pgsql-general по дате отправления: