Hello,
If you can be of any help
please feel free.
PostgreSQL V7.1
==================================================
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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!