Postgre cant start - Mailing list pgsql-bugs

From Olivier Bessière
Subject Postgre cant start
Date
Msg-id 003c01c89421$961b9200$c252b600$@com
Whole thread Raw
Responses Re: Postgre cant start
List pgsql-bugs
<div class="Section1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal">If you can be of any help…
pleasefeel free.<p class="MsoNormal">PostgreSQL V7.1<p class="MsoNormal"> <p
class="MsoNormal">==================================================<pclass="MsoNormal">[postgres@x bin]$ postgres
start<pclass="MsoNormal">DEBUG:  database system was interrupted being in recovery at 2008-04-01 00:31:20 CST<p
class="MsoNormal">       This propably means that some data blocks are corrupted<p class="MsoNormal">        and you
willhave to use last backup for recovery.<p class="MsoNormal">DEBUG:  CheckPoint record at (6, 2667839868)<p
class="MsoNormal">DEBUG: Redo record at (6, 2667793068); Undo record at (0, 0); Shutdown FALSE<p
class="MsoNormal">DEBUG: NextTransactionId: 58839239; NextOid: 18823136<p class="MsoNormal">DEBUG:  database system was
notproperly shut down; automatic recovery in progress...<p class="MsoNormal">DEBUG:  redo starts at (6, 2667793068)<p
class="MsoNormal">FATAL2:  cannot read block 1802 of pg_log: Success<p class="MsoNormal"> <p class="MsoNormal">[root@x
log]#cat boot.log |grep postmaster<p class="MsoNormal">Apr  1 04:48:42 mail1 postgres: postmaster shutdown failed<p
class="MsoNormal">Apr 1 04:49:38 mail1 postgres: postmaster shutdown failed<p class="MsoNormal">Apr  1 04:51:40 mail1
postgres:postmaster shutdown failed<p class="MsoNormal">Mar 31 22:59:14 mail1 postgres: postmaster shutdown failed<p
class="MsoNormal">Mar31 22:59:32 mail1 postgres: postmaster shutdown failed<p class="MsoNormal">Mar 31 23:01:45 mail1
postgres:postmaster shutdown failed<p class="MsoNormal">Mar 31 23:38:10 mail1 postgres: postmaster shutdown failed<p
class="MsoNormal"> <pclass="MsoNormal">Regards<p class="MsoNormal"> <p class="MsoNormal"><b><span
style="font-family:"CenturyGothic","sans-serif"">Olivier Bessière</span></b><p class="MsoNormal"><span
style="font-family:"CenturyGothic","sans-serif"">Network and System Engineer</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"CenturyGothic","sans-serif""> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"CenturyGothic","sans-serif"; 
color:#76923C">Think green before printing!</span><span style="color:#76923C"></span><p class="MsoNormal"> </div><br
/><br/>__________ Information from ESET NOD32 Antivirus, version of virus signature database 2992 (20080401)
__________<br/><br />The message was checked by ESET NOD32 Antivirus.<br /><br /><a
href="http://www.eset.com">http://www.eset.com</a><br/> 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
Next
From: Tom Lane
Date:
Subject: Re: Postgre cant start