Thread: PostgreSQL recovery when lost some file in data\global
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
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 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
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:
Hi Tuan Hoang Anh,Are you able to bring up the cluster ??Please let us know what problem you are facing.ThanksVenkatOn Tue, Sep 27, 2011 at 12:08 PM, tuanhoanganh <hatuan05@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