Обсуждение: Recovery mode for a WAL-based slave

Поиск
Список
Период
Сортировка

Recovery mode for a WAL-based slave

От
Wells Oliver
Дата:
Is the server perpetually in recovery mode?

Looking at PGAdmin, "in recovery?" is "yes", but replay location is the same as receive location, and the data is absolutely up to date.

Is the recovery bit an issue, or just SOP?

Thanks.

--
Wells Oliver
wellsoliver@gmail.com

Re: Recovery mode for a WAL-based slave

От
"Kevin Grittner"
Дата:
Wells Oliver <wellsoliver@gmail.com> wrote:

> Looking at PGAdmin, "in recovery?" is "yes", but replay location
> is the same as receive location, and the data is absolutely up to
> date.
>
> Is the recovery bit an issue, or just SOP?

SOP.  It's due to the gradual evolution of the hot standby feature
from the transaction logs which were originally used just for crash
recovery.

-Kevin