PostgreSQL recovery when lost some file in data\global

Hi Tuan Hoang Anh,

Are you able to bring up the cluster ??

Please let us know what problem you are facing.

Thanks
Venkat

On Tue, Sep 27, 2011 at 12:08 PM, tuanhoanganh <hatuan05@gmail.com> wrote:

I can start postgresql but there is error

2011-09-28 15:09:37 ICT LOG: database system was interrupted; last known up
at 2011-09-26 08:03:39 ICT
2011-09-28 15:09:37 ICT LOG: database system was not properly shut down;
automatic recovery in progress
2011-09-28 15:09:37 ICT LOG: consistent recovery state reached at 0/7652700
2011-09-28 15:09:37 ICT LOG: record with zero length at 0/7652700
2011-09-28 15:09:37 ICT LOG: redo is not required
2011-09-28 15:09:37 ICT LOG: database system is ready to accept connections
2011-09-28 15:09:38 ICT LOG: autovacuum launcher started
2011-09-28 15:09:38 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:39 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:40 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:41 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:42 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:43 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:44 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:45 ICT ERROR: could not open file "global/11867": No such
file or directory
2011-09-28 15:09:46 ICT ERROR: could not open file "global/11867": No such
file or directory

Maybe all file in base directory are ok, postgresql only lost some file in
global.
Please help me. Sorry for my English

Tuan Hoang Anh

On Tue, Sep 27, 2011 at 4:55 PM, Venkat Balaji <venkat.balaji@verse.in>wrote: