postgres doesn't start after crash
От | Patrick Brückner |
---|---|
Тема | postgres doesn't start after crash |
Дата | |
Msg-id | 4ADFB30A.9050200@gmail.com обсуждение исходный текст |
Ответы |
Re: postgres doesn't start after crash
Re: postgres doesn't start after crash |
Список | 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?
В списке pgsql-general по дате отправления: