Re: postgres doesn't start after crash

Did you find what the reason of crash was?

Log seems that the data is corrupted as the system was
crashed. Smart way it to reload data from the valid backup and start your work.
If you don’t have a valid backup then at last touch the file (68157) and try to
restart your db.

--
Thanks
Sam DJ

--- On Thu, 22/10/09, Patrick Brückner <payday81(at)gmail(dot)com> wrote:

From: Patrick Brückner <payday81(at)gmail(dot)com>
Subject: [GENERAL] postgres doesn't start after crash
To: pgsql-general(at)postgresql(dot)org
Date: Thursday, 22 October, 2009, 1:19 AM

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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Yahoo! India has a new look. Take a sneak peek http://in.yahoo.com/trynew