panic: postmaster restart failed

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: panic: postmaster restart failed
Date: 2002-12-23 13:54:36
Message-ID: 008c01c2aa8a$d438dba0$7100a8c0@henrik
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello all,

tonight, at 4:59 am my db-server crashed once more.
This time, I could still ping the server, however,
I couldn't connect to pgsql or to sshd

So I rebooted and was then able to log onto the server.

Unfortunately, the postmaster didn't start up.

It said in pgsql.log:

postmaster successfully started
LOG: database system was interrupted being in recovery at 2002-12-23
05:19:10 CET
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 6/730584A8
LOG: redo record is at 6/730584A8; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 65055127; next oid: 53301088
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 6/730584E8
PANIC: read of clog file 62, offset 8192 failed: Erfolg
LOG: startup process (pid 1319) was terminated by signal 6
LOG: aborting startup due to startup process failure

----

so I followed the instruction to recover my last backup, which worked fine.

finally today I will setup a new linux box just to see if it's really a
hardware failure.

have a merry christmas all,

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Choe 2002-12-23 14:12:55 encryption function
Previous Message Peter Choe 2002-12-23 13:41:37 createdb creates a default table