Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1egLic-0000YX-6h for pgsql-docs@arkaria.postgresql.org; Tue, 30 Jan 2018 02:32:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1egLia-0005JZ-Qs for pgsql-docs@arkaria.postgresql.org; Tue, 30 Jan 2018 02:32:16 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1egLia-0005JP-AC for pgsql-docs@lists.postgresql.org; Tue, 30 Jan 2018 02:32:16 +0000 Received: from mail-wm0-x22b.google.com ([2a00:1450:400c:c09::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1egLiT-0008Pe-3Q for pgsql-docs@postgresql.org; Tue, 30 Jan 2018 02:32:14 +0000 Received: by mail-wm0-x22b.google.com with SMTP id 141so37257618wme.3 for ; Mon, 29 Jan 2018 18:32:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=room118solutions.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=CxcrqKFhZhgGeYAZwiwi0UCcRHJz2PgabaKP+hIvD1w=; b=GpwqlSUcv/z5Xwk2efiq+PRaHb2TikkBTU8YW9O3BwUHE741b3DeG0tAbkSPwyANxq t0iFxHV68+FcGfjHVw3usxoLS/nPUK5ymNUpmhXHyoKIb5NElAjKS3rxdUkC0UgMF3Sr +53qtGDb5JIQIZNSW25PQfOZ3oRJM4oMEBEE4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=CxcrqKFhZhgGeYAZwiwi0UCcRHJz2PgabaKP+hIvD1w=; b=M8NhHpKaT4uGk4RhxhbdQC7PxYTzUsUJgt+igp8Rd2q2yJUC5iRtybWioxQAnIjrQz F+c7F82wsO4IjphYvWCudFpftb0evmNz2If+si6Ht86Gnh2GCbwFhSM9SWqR77oHKcxP /U6svCKf/3+4bgk/xKxWEc4ZdA2PrSnAn+vQf9HdRc4RC+x9JRFRTJYfCrsWXNueAN5c SAQULkYWXrTkGeBYLtbIr0my6vGetbC3ePbFaq9BQ72i81gNSyj4R4dvQ11amHcXz15w 3HsRV2CQA1FN7yxVcxorqUmBA+hILkwdRhHtFAlH6UwMewA4MUj7BxOAlRUxMYaj+8Ix Q8Gw== X-Gm-Message-State: AKwxytcANLD5X82KGU7qINIaodFF5xAuN1ktZCgbNHw3kjifTZVGMIl3 5EGMYb+f6Iebd39WqMj/WrdOOQ70e6gLkT4gBcH5ig== X-Google-Smtp-Source: AH8x226u/wQTDAfTyqTgXJJLrDlx57wQG/7TSOactU/QgcpTArhVlNFIibFsNnyTo2SCQJvZigPgOksY2Pm11jL1R2o= X-Received: by 10.28.134.140 with SMTP id i134mr21978654wmd.57.1517279527218; Mon, 29 Jan 2018 18:32:07 -0800 (PST) MIME-Version: 1.0 Received: by 10.223.134.105 with HTTP; Mon, 29 Jan 2018 18:31:46 -0800 (PST) X-Originating-IP: [108.30.178.16] In-Reply-To: <20180127150543.GB30459@momjian.us> References: <20171218213041.25744.8414@wrigleys.postgresql.org> <20180126002618.GA20836@momjian.us> <20180127150543.GB30459@momjian.us> From: Jim Ryan Date: Mon, 29 Jan 2018 21:31:46 -0500 Message-ID: Subject: Re: pg_upgrade docs are confusing if PostgreSQL's versioning system/language isn't known to reader To: Bruce Momjian Cc: "David G. Johnston" , "pgsql-docs@postgresql.org" Content-Type: multipart/alternative; boundary="001a114439d03ec9fb0563f52bf5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a114439d03ec9fb0563f52bf5 Content-Type: text/plain; charset="UTF-8" This looks great. Thanks for working on it. Jim On Sat, Jan 27, 2018 at 10:05 AM, Bruce Momjian wrote: > On Fri, Jan 26, 2018 at 11:35:09AM -0700, David G. Johnston wrote: > > On Friday, January 26, 2018, Jim Ryan wrote: > > > > Hey Bruce, > > > > Thanks for working on this, but wouldn't pg_upgrade be needed from > 10.1 to > > 10.2? Aren't those considered major versions, or am I > misunderstanding? > > > > The source of my (and potentially others) confusion is if from 9.1 > to 9.2 > > is considered a major version change or not. I think most users > would > > assume from 9.x to 10.x is a major version change. The ambiguity is > in 9.x > > to 9.y. > > > > > > > > Which is why we changed ;) > > > > Starting with 10 the one and only value after the decimal is a minor > version > > bug fix release. The next major version will be 11. > > > > Of versions beginning with 9 there were 7 major versions - 9.0 to 9.6; > the > > third position value denoted the minor bug fix release. > > > > pg-upgrade is only required for upgrading between major versions. > > > > On our homeoage we list every major release that is currently supported. > > I decided I needed to be more explicit about the major version numbers > so I have added major and minor examples for the 9.6.x series and 10.x > series releases. Patch attached. > > -- > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + As you are, so once was I. As I am, so you will be. + > + Ancient Roman grave inscription + > --001a114439d03ec9fb0563f52bf5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This looks great.=C2=A0 Thanks for working on it.

=
Jim

On Sat, Jan 27, 2018 at 10:05 AM, Bruce Momjian = <bruce@momjian.us<= /a>> wrote:
On= Fri, Jan 26, 2018 at 11:35:09AM -0700, David G. Johnston wrote:
> On Friday, January 26, 2018, Jim Ryan <jim@room118solutions.com> wrote:
>
>=C2=A0 =C2=A0 =C2=A0Hey Bruce,
>
>=C2=A0 =C2=A0 =C2=A0Thanks for working on this, but wouldn't pg_upg= rade be needed from 10.1 to
>=C2=A0 =C2=A0 =C2=A010.2?=C2=A0 Aren't those considered major versi= ons, or am I misunderstanding?
>
>=C2=A0 =C2=A0 =C2=A0The source of my (and potentially others) confusion= is if from 9.1 to 9.2
>=C2=A0 =C2=A0 =C2=A0is considered a major version change or not.=C2=A0 = I think most users would
>=C2=A0 =C2=A0 =C2=A0assume from 9.x to 10.x is a major version change.= =C2=A0 The ambiguity is in 9.x
>=C2=A0 =C2=A0 =C2=A0to 9.y.=C2=A0=C2=A0
>
>
>
> Which is why we changed ;)
>
> Starting with 10 the one and only value after the decimal is a minor v= ersion
> bug fix release.=C2=A0 The next major version will be 11.
>
> Of versions beginning with 9 there were 7 major versions - 9.0 to 9.6;= the
> third position value denoted the minor bug fix release.
>
> pg-upgrade is only required for upgrading between major versions.
>
> On our homeoage we list every major release that is currently supporte= d.

I decided I needed to be more explicit about the major version numbe= rs
so I have added major and minor examples for the 9.6.x series and 10.x
series releases.=C2=A0 Patch attached.

--
=C2=A0 Bruce Momjian=C2=A0 <bruce@mo= mjian.us>=C2=A0 =C2=A0 =C2=A0 =C2=A0 http://momjian.us
=C2=A0 EnterpriseDB=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0http://enterprisedb.com
+ As you are, so once was I.=C2=A0 As I am, so you will be. +
+=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 Ancient Roman grave inscription +

--001a114439d03ec9fb0563f52bf5--