Postgre cant start

[Olivier Bessière <obessiere(at)boomerangpharma(dot)com>]

Hello,

 

If you can be of any help… please feel free.

PostgreSQL V7.1

 

==================================================

[postgres(at)x bin]$ postgres start

DEBUG:  database system was interrupted being in recovery at 2008-04-01 00:31:20 CST

        This propably means that some data blocks are corrupted

        and you will have to use last backup for recovery.

DEBUG:  CheckPoint record at (6, 2667839868)

DEBUG:  Redo record at (6, 2667793068); Undo record at (0, 0); Shutdown FALSE

DEBUG:  NextTransactionId: 58839239; NextOid: 18823136

DEBUG:  database system was not properly shut down; automatic recovery in progress...

DEBUG:  redo starts at (6, 2667793068)

FATAL 2:  cannot read block 1802 of pg_log: Success

 

[root(at)x log]# cat boot.log |grep postmaster

Apr  1 04:48:42 mail1 postgres: postmaster shutdown failed

Apr  1 04:49:38 mail1 postgres: postmaster shutdown failed

Apr  1 04:51:40 mail1 postgres: postmaster shutdown failed

Mar 31 22:59:14 mail1 postgres: postmaster shutdown failed

Mar 31 22:59:32 mail1 postgres: postmaster shutdown failed

Mar 31 23:01:45 mail1 postgres: postmaster shutdown failed

Mar 31 23:38:10 mail1 postgres: postmaster shutdown failed

 

Regards

 

Olivier Bessière

Network and System Engineer

 

Think green before printing!

 

__________ Information from ESET NOD32 Antivirus, version of virus signature database 2992 (20080401) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com