Re: PostgreSQL service won't start after bad computer time

Bill Moran <wmoran@potentialtech.com> writes:
> On 6/3/11 8:52:15 AM, Rob Richardson wrote:
>> I did some testing involving changing a computer�s time, and left the
>> time one year early (6/3/2010 instead of 2011). The PostgreSQL service
>> now will not start up. Here�s what the log says:
>>
>> 2011-06-03 08:46:56 EDTLOG: record with zero length at 9/8E080968
>> 2011-06-03 08:46:56 EDTLOG: redo done at 9/8E07FA78
>> 2011-06-03 08:46:56 EDTLOG: last completed transaction was at log time
>> 2010-06-03 08:11:17.531-04
>> 2011-06-03 08:46:56 EDTFATAL: xlog flush request 18/A2BE3510 is not
>> satisfied --- flushed only to 9/8E080968
>> 2011-06-03 08:46:56 EDTCONTEXT: writing block 0 of relation global/1261_vm

>> How do we recover from this?

> Reset the time to be correct.

I don't think that failure has anything to do with system clock time.
It looks more like filesystem corruption or missing pg_xlog files.

            regards, tom lane