[ADMIN] 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.

[Kevin Grittner]

Post by Wells Oliver
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