Re: recovery_target_time and standby_mode - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: recovery_target_time and standby_mode
Date
Msg-id CAB7nPqSSHONNoH4dyj4f_1roDct9-VemT+Z18JYDZ+MH_sd7LQ@mail.gmail.com
Whole thread Raw
In response to Re: recovery_target_time and standby_mode  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On Thu, Nov 6, 2014 at 10:41 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Thu, Nov 6, 2014 at 10:00 AM, Greg Stark <stark@mit.edu> wrote:
>> On Thu, Nov 6, 2014 at 12:32 AM, Josh Berkus <josh@agliodbs.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.
Just adding: ... On the new timeline that master is bumping to. If the
standby already replayed of the point where WAL forked on master, then
the standby should be rewinded.
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: recovery_target_time and standby_mode
Next
From: Josh Berkus
Date:
Subject: Re: recovery_target_time and standby_mode