Re: pg_upgrade resets timeline to 1

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Christoph Berg <myon(at)debian(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Marco Nenciarini <mnencia(at)debian(dot)org>
Subject: Re: pg_upgrade resets timeline to 1
Date: 2015-05-28 14:44:54
Message-ID: 20150528144454.GC18188@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 28, 2015 at 10:39:15AM -0400, Noah Misch wrote:
> > > It looks like an upgrade from 9.1.x to 9.3.0 or later has always set the new
> > > timeline identifier (TLI) to 1. My testing confirms this for an upgrade from
> > > 9.1.16 to 9.4.1 and for an upgrade from 9.1.16 to 9.4.2, so I failed to
> > > reproduce your report. Would you verify the versions you used? If you were
> > > upgrading from 9.3.x, I _can_ reproduce that.
> >
> > Sorry, the "9.1" was a typo, the system was on 9.2.11 before/during
> > pg_upgrade.
>
> I ran 9.2.11-to-9.4.1 and 9.2.11-to-9.4.2 upgrades through my script. Both of
> them set TLI=1. I would be inclined to restore compatibility if this were a
> 9.4.2 regression, but upgrades from 9.2 to 9.4 have always done that.

Right, it was only 9.3 to 9.4.0 (and 9.4.1) that restored the timeline.
Restores to 9.4.2 do not.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2015-05-28 15:02:34 Re: pg_upgrade resets timeline to 1
Previous Message Dan Langille 2015-05-28 14:43:34 Re: PGCon hacker lounge