Re: Recovery mode for a WAL-based slave

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Wells Oliver" <wellsoliver(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Recovery mode for a WAL-based slave
Date: 2012-04-11 17:24:32
Message-ID: 4F8578000200002500046DE1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Wells Oliver <wellsoliver(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2012-04-11 22:20:34 Definitive logrotate solution?
Previous Message Wells Oliver 2012-04-11 17:17:54 Recovery mode for a WAL-based slave