Skip site navigation (1) Skip section navigation (2)

Please Help... Service fails to start

From: Hengky Lie <hengkyliwandouw(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Please Help... Service fails to start
Date: 2009-11-03 01:55:06
Message-ID: 992E4ADE-09CE-4095-AB27-82C739C52B3B@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Dear Friends,

I really need help for my problem, 7 days ago Postgresql service fails  
to start and i have no backup ! (OS: Windows XP Pro). I tried googling  
everywhere but didn't find any solution.

I had tried to start the service manually from control panel, it  
started for about 5 seconds, after that stop again.

This is the error  log  :

2009-11-02 10:13:29 LOG:  database system was interrupted while in  
recovery at 2009-10-30 06:33:49 Malay Peninsula Standard Time
2009-11-02 10:13:29 HINT:  This probably means that some data is  
corrupted and you will have to use the last backup for recovery.
2009-11-02 10:13:29 LOG:  checkpoint record is at 3/DA21E418
2009-11-02 10:13:29 LOG:  redo record is at 3/DA21E418; undo record is  
at 0/0; shutdown FALSE
2009-11-02 10:13:29 LOG:  next transaction ID: 0/139856773; next OID:  
28846
2009-11-02 10:13:29 LOG:  next MultiXactId: 4; next MultiXactOffset: 7
2009-11-02 10:13:29 LOG:  database system was not properly shut down;  
automatic recovery in progress
2009-11-02 10:13:29 LOG:  redo starts at 3/DA21E468
2009-11-02 10:13:35 FATAL:  could not access status of transaction  
139856778
2009-11-02 10:13:35 DETAIL:  Could not read from file "pg_clog/0085"  
at offset 98304: Permission denied.
2009-11-02 10:13:35 CONTEXT:  xlog redo commit: 2009-10-20 17:20:42
2009-11-02 10:13:38 LOG:  startup process (PID 1284) exited with exit  
code 1
2009-11-02 10:13:38 LOG:  aborting startup due to startup process  
failure
2009-11-02 10:13:38 LOG:  logger shutting down

It seems that i still have chance to redo or undo the record that  
caused this error. But how to do that ? How to find that file ?  
Postgresql data folder only contain numbered filename.

Thank you for any help.

Responses

pgsql-admin by date

Next:From: Anj AduDate: 2009-11-03 02:47:00
Subject: Re: vacuumdb knowledge of prior vacuum
Previous:From: Alvaro HerreraDate: 2009-11-03 01:39:26
Subject: Re: vacuumdb knowledge of prior vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group