Postgre cant start - Mailing list pgsql-bugs

Hello,

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

PostgreSQL V7.1

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

[postgres@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@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!