Re: [GENERAL] Postgres fails to start

2015-04-07 Thread Haiming Zhang
@postgresql.org Subject: Re: [GENERAL] Postgres fails to start On Tue, Apr 7, 2015 at 10:46 AM, Haiming Zhang haiming.zh...@redflex.com.au wrote: Thank you for replying. The file was there, is that ok to remove the corrupted file to recover postgres? base/2008723533/2107262657.2 Be careful here, I would

[GENERAL] Postgres fails to start

2015-04-06 Thread Haiming Zhang
Hi All, I have experienced that Postgres services was not able to start, I tried from Services and command, and both were failed. Here are the logs I got, please help. (I am using postgres 9.1 and there are plenty disk space left). 2015-04-07 09:01:28 EST LOG: database system was interrupted

Re: [GENERAL] Postgres fails to start

2015-04-06 Thread Michael Paquier
On Tue, Apr 7, 2015 at 10:46 AM, Haiming Zhang haiming.zh...@redflex.com.au wrote: Thank you for replying. The file was there, is that ok to remove the corrupted file to recover postgres? base/2008723533/2107262657.2 Be careful here, I would recommend taking a file-level snapshot before going

Re: [GENERAL] Postgres fails to start

2015-04-06 Thread Michael Paquier
On Tue, Apr 7, 2015 at 9:25 AM, Haiming Zhang haiming.zh...@redflex.com.au wrote: 2015-04-07 09:01:43 EST LOG: unrecognized win32 error code: 1392 [...] In Windows world, 1392 = ERROR_FILE_CORRUPT = the file or directory is corrupted and unreadable:

Re: [GENERAL] Postgres fails to start

2015-04-06 Thread Haiming Zhang
-Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: Tuesday, 7 April 2015 11:36 AM To: Haiming Zhang Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres fails to start On Tue, Apr 7, 2015 at 9:25 AM, Haiming Zhang haiming.zh...@redflex.com.au wrote