Re: PostgreSQL service won't start after bad computer time
От | Tom Lane |
---|---|
Тема | Re: PostgreSQL service won't start after bad computer time |
Дата | |
Msg-id | 28377.1307117057@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: PostgreSQL service won't start after bad computer time (Bill Moran <wmoran@potentialtech.com>) |
Ответы |
Re: PostgreSQL service won't start after bad computer time
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: