postgres doesn't start after crash

From: Patrick Brückner <payday81(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres doesn't start after crash
Date: 2009-10-22 01:19:06
Message-ID: 4ADFB30A.9050200@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message semi-ambivalent 2009-10-22 02:17:44 auto-filling a field on insert
Previous Message Scott Bailey 2009-10-22 01:05:06 Re: cast numeric with scale and precision to numeric plain