Re: BUG #14109: pg_rewind fails to update target control file in one scenario

2016-04-25 17:45 GMT+02:00 John Lumby <johnlumby(at)hotmail(dot)com>:

>
>
> ----------------------------------------
> > Subject: Re: [BUGS] BUG #14109: pg_rewind fails to update target control
> file in one scenario
> > To: johnlumby(at)hotmail(dot)com; michael(dot)paquier(at)gmail(dot)com
> > CC: pgsql-bugs(at)postgresql(dot)org
> > From: julien(dot)rouhaud(at)dalibo(dot)com
> > Date: Mon, 25 Apr 2016 16:53:19 +0200
> >
> > On 25/04/2016 16:36, John Lumby wrote:
> >>> From: michael(dot)paquier(at)gmail(dot)com
> >>> To: johnlumby(at)hotmail(dot)com
> >>> CC: pgsql-bugs(at)postgresql(dot)org
> >>>
> >>> On Mon, Apr 25, 2016 at 10:48 PM, John Lumby <johnlumby(at)hotmail(dot)com>
> 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