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.bal...@verse.in>wrote: > 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 <hatua...@gmail.com> wrote: > >> I am running PostgreSQL 9.0.1 32bit on windows 2003. Last night my disk >> had some problem and i lost some file in data\global. >> Is there anyway to recovery postgresql. >> >> Thanks in advance. Sorry for my English. >> >> Tuan Hoang Anh >> > >
