Re: Help ! Service fails to start

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Make sure you have the proper permission/privilege to your pg_clog
folder. Postgres trying to apply your log to recover but complain about
" Permission denied". 

Regards,
      Husam 

-----Original Message-----
From: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Hengky Lie
Sent: Sunday, November 01, 2009 9:19 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject:  Help ! Service fails to start

Dear Friends,

I really need advise for my problem, 7 days ago Postgresql service  
fails to start and i have no backup ! (OS: Windows XP Pro)

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

This is the error in log files :

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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
****************************************************************************************** 
This message may contain confidential or proprietary information intended only for the use of the 
addressee(s) named above or may contain information that is legally privileged. If you are 
not the intended addressee, or the person responsible for delivering it to the intended addressee, 
you are hereby notified that reading, disseminating, distributing or copying this message is strictly 
prohibited. If you have received this message by mistake, please immediately notify us by  
replying to the message and delete the original message and any copies immediately thereafter. 

Thank you. 
****************************************************************************************** 
FACLD


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux