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?
-- Sent via pgsql-general
mailing list (
pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general