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@hotmail.com>:

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