I am unable to start postgresql. I cannot start it from PT2 or from pgAdmin III not can I start the service. I am using postgres 8.0 on an XP.
Here is a copy of the log file attempting to start ipostgres:
2009-05-11 00:31:48 LOG: database system was interrupted while in recovery at 2009-05-10 02:14:05 Eastern Daylight Time
2009-05-11 00:31:48 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2009-05-11 00:31:49 LOG: checkpoint record is at 33/71533738
2009-05-11 00:31:49 LOG: redo record is at 33/71533738; undo record is at 0/0; shutdown FALSE
2009-05-11 00:31:49 LOG: next transaction ID: 49470763; next OID: 2410317
2009-05-11 00:31:49 LOG: database system was not properly shut down; automatic recovery in progress
2009-05-11 00:31:49 LOG: redo starts at 33/71533778
2009-05-11 00:32:02 PANIC: could not read block 574 of relation 1663/1312090/1916124: Permission denied
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
2009-05-11 00:32:02 LOG: startup process (PID 2700) was terminated by signal 3
2009-05-11 00:32:02 LOG: aborting startup due to startup process failure
2009-05-11 00:32:03 LOG: logger shutting down
What can I do to fix the problem?