Postgre cant start

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!