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?
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 |