Search Postgresql Archives

Re: PostgreSQL recovery when lost some file in data\global

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

 



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@xxxxxxxx> 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 <hatuan05@xxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux