Thread: Recovery mode for a WAL-based slave

Recovery mode for a WAL-based slave

From
Wells Oliver
Date:
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

From
"Kevin Grittner"
Date:
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