On Thu, Nov 6, 2014 at 10:00 AM, Greg Stark <stark(at)mit(dot)edu> wrote:
> On Thu, Nov 6, 2014 at 12:32 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> When the recovery_target_time is reached, switch to streaming
>> replication and stay a standby.
>
> Then shouldn't he just not specify a recovert_target at all? That's
> the default behaviour for standby_mode on, the whole point of
> recovery_target is to specify when to stop recovery and leave standby
> mode, no?
Agreed with Greg, once a target recovery is switched the node gets out
of recovery. What the user should have done here is not specify
recovery_target_time in the standby's recovery.conf such as it follows
the master through streaming.
--
Michael