Hi,
after a computer crash my postgres 8.2.14 installation under Windows XP
SP3 doesn't start anymore. Here is the log file:
C:\Dokumente und Einstellungen\Admin>2009-10-21 23:57:09 LOG: database
system was interrupted while in recovery at 2009-10-21 22:21:14
2009-10-21 23:57:09 HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2009-10-21 23:57:09 LOG: checkpoint record is at 24B/DD08FFA0
2009-10-21 23:57:09 LOG: redo record is at 24B/DD08FFA0; undo record is
at 0/0; shutdown FALSE
2009-10-21 23:57:09 LOG: next transaction ID: 0/296859064; next OID: 712969
2009-10-21 23:57:09 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2009-10-21 23:57:09 LOG: database system was not properly shut down;
automatic recovery in progress
2009-10-21 23:57:09 LOG: redo starts at 24B/DD090010
2009-10-21 23:57:10 FATAL: could not count blocks of relation
1663/68065/68157: Permission denied
2009-10-21 23:57:10 CONTEXT: xlog redo insert: rel 1663/68065/68157; tid
165304 9/10
2009-10-21 23:57:10 LOG: startup process (PID 3860) exited with exit code 1
2009-10-21 23:57:10 LOG: aborting startup due to startup process failure
I assume it has something to do with the FATAL: could not count blocks
of relation 1663/68065/68157: Permission denied error. Is there any
chance that I can repair the data without doing a backup?