Re: trying to run PITR recovery

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: trying to run PITR recovery
Дата
Msg-id 1175268891.4386.781.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: trying to run PITR recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: trying to run PITR recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Sun, 2007-03-25 at 20:57 -0400, Tom Lane wrote:
> Warren Little <Warren.Little@MeridiasCapital.com> writes:
> > I'm testing my PITR recovery procedures and something doesn't look
> > right.
> > The following is from the logs upon starting postgres with
> > recovery.conf file in place
>
> > @ 2007-03-23 05:57:33 MDTLOG:  restored log file
> > "000000010000011A000000FD" from archive
> > @ 2007-03-23 05:57:35 MDTLOG:  incorrect resource manager data
> > checksum in record at 11A/FD492B20
> > @ 2007-03-23 05:57:35 MDTLOG:  redo done at 11A/FD492210
>
> > My concern is that there were many more logfiles to be played
> > following "00000010000011A000000FD"
> > (ie 000000010000011E0000005C) yet it appears the recovery stop at
> > that point and called it good.
>
> Perhaps you have a bad copy of that particular log segment file?
> The "incorrect checksum" failure is normal in certain circumstances
> (eg, where the system crashes partway through writing out a large
> WAL record), which is why the code treats it as indicating the end
> of WAL.  But in this case it looks more like corrupt data ...

Tom,

I think there is a problem here. If we stop before the end of logs we
should be incrementing the timeline id.

I'm not going to think about it right now, but I'll think on that next
week. Not the most likely problem we'll ever see, I grant you.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: trying to run PITR recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance on views