Re: recovery_target_time and last completed transaction log time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: recovery_target_time and last completed transaction log time
Дата
Msg-id 3921.1225337971@sss.pgh.pa.us
обсуждение исходный текст
Ответ на recovery_target_time and last completed transaction log time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Regarding the LOG message, it is confusing to have a recovery.conf
> file which contains this:
> recovery_target_time = '2008-10-16 17:00:00.0'
> and see this in the log:
> [2008-10-16 23:04:26.006 CDT] 19951 LOG:  last completed transaction
> was at log time 2008-10-16 17:00:23.205347-05

Actually, I think this *is* a bug: recoveryLastXTime is being set in
entirely the wrong place, ie, where we are *considering* whether to
apply a commit rather than after we have decided to do so.  The
result is just a misleading log message, so not too terrible, but
we should fix it.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Please make sure your patches are on the wiki page
Следующее
От: David Fetter
Дата:
Сообщение: Re: pre-MED