2016-04-25 17:45 GMT+02:00 John Lumby <[email protected]>:
>
>
> ----------------------------------------
> > Subject: Re: [BUGS] BUG #14109: pg_rewind fails to update target control
> file in one scenario
> > To: [email protected]; [email protected]
> > CC: [email protected]
> > From: [email protected]
> > Date: Mon, 25 Apr 2016 16:53:19 +0200
> >
> > On 25/04/2016 16:36, John Lumby wrote:
> >>> From: [email protected]
> >>> To: [email protected]
> >>> CC: [email protected]
> >>>
> >>> On Mon, Apr 25, 2016 at 10:48 PM, John Lumby <[email protected]>
> wrote:
> >>>>
> >>>> Note the difference in timeline
> > Did you set the recovery_target_timeline parameter to "latest" in the
> > recovery.conf file? (see
> >
> http://www.postgresql.org/docs/current/static/recovery-target-settings.html
> ).
>
> Thanks Julien, no I did not, I will re-test with that later, on
> 9.5.2
> Meanwhile one question on that. The documentation states
> "Setting this to latest recovers
> to the latest timeline found in the archive, which ..."
> However I am running my systems with
> archive_mode = off
> I am wondering whether
> recovery_target_timeline parameter = "latest"
> is expected to work reliably to fix my particular problem when archiving
> is not in effect.
>
>
It also works with the streaming replication since at least 9.3. So, yes,
it should work.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
