From Isabella.Ghiurea@nrc-cnrc.gc.ca Thu Oct  25 14:53:35 2018
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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFh1E-0002Z0-1O
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 14:53:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFh1C-0002sh-JJ
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 14:53:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
	id 1gFh1C-0002sL-BH
	for pgsql-admin@lists.postgresql.org; Thu, 25 Oct 2018 14:53:50 +0000
Received: from mx.ssan.egs-seg.gc.ca ([205.193.229.132])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
	id 1gFh16-0008RC-5I
	for pgsql-admin@postgresql.org; Thu, 25 Oct 2018 14:53:46 +0000
Received: from DC01ZWH0020.paz.nrc.gc.ca ([167.37.58.16])
	by mx.ssan.egs-seg.gc.ca  with ESMTP id w9PEraFY013752-w9PEraFa013752
	(version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=CAFAIL)
	for <pgsql-admin@postgresql.org>; Thu, 25 Oct 2018 10:53:36 -0400
Received: from DC01ZWH0011.Corp.nrc.gc.ca (167.37.54.205) by
 DC01ZWH0020.paz.nrc.gc.ca (167.37.58.16) with Microsoft SMTP Server (TLS) id
 15.0.1347.2; Thu, 25 Oct 2018 10:53:34 -0400
Received: from DC01ZWH0011.Corp.nrc.gc.ca (167.37.54.205) by
 DC01ZWH0011.Corp.nrc.gc.ca (167.37.54.205) with Microsoft SMTP Server (TLS)
 id 15.0.1347.2; Thu, 25 Oct 2018 10:53:35 -0400
Received: from DC01ZWH0011.Corp.nrc.gc.ca ([167.37.54.205]) by
 DC01ZWH0011.Corp.nrc.gc.ca ([167.37.54.205]) with mapi id 15.00.1347.000;
 Thu, 25 Oct 2018 10:53:35 -0400
From: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: upgrade slave  in streaming replication from PG 10.4 to 10.5.1
Thread-Topic: upgrade slave  in streaming replication from PG 10.4 to 10.5.1
Thread-Index: AQHUbHJw/HVVC1eep0OsrJfWxPv6Yw==
Date: Thu, 25 Oct 2018 14:53:35 +0000
Message-ID: <1540479215718.82040@nrc-cnrc.gc.ca>
Accept-Language: en-US, en-CA
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-ms-exchange-transport-fromentityheader: Hosted
x-originating-ip: [167.37.48.8]
Content-Type: multipart/alternative;
	boundary="_000_154047921571882040nrccnrcgcca_"
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

--_000_154047921571882040nrccnrcgcca_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Gmorning List,

we have a system running  PG streaming replication using repmgr4 , PG hosts=
 are running Cent OS 7 with  PG 10.4, we have a request to upgrade to PG 10=
.5 , my plan is to upgrade the slave db host first and later on /next month=
 switch over and upgrade the existing PG master, we are using the following=
 PG extensions: citext , pg_sphere,pg_stat_statements,pgrowlocks.

Also in existing PG 10.4 cfg:/data/ pg_wal is a link  and we have cfg multi=
ple tablespaces

Are any issues   related to replication if we are upgrading the  PG slave h=
ost first ,  ?


Thank you

Isabella

--_000_154047921571882040nrccnrcgcca_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none"><!--P{margin-top:0;margin-b=
ottom:0;} --></style>
</head>
<body dir=3D"ltr" style=3D"font-size:12pt;color:#000000;background-color:#F=
FFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Gmorning List,</p>
<p>we have a system running &nbsp;PG streaming replication&nbsp;using repmg=
r4 , PG hosts are running Cent OS 7&nbsp;with&nbsp; PG 10.4, we have a requ=
est to upgrade to PG 10.5 , my plan is to upgrade the slave db host first a=
nd later on /next month switch over and upgrade the
 existing PG master, we are using the following PG extensions: citext&nbsp;=
, pg_sphere,pg_stat_statements,pgrowlocks.
</p>
<p>Also in existing PG 10.4 cfg:/data/ pg_wal is a link &nbsp;and we have c=
fg multiple tablespaces
<br>
</p>
<p>Are any issues&nbsp; &nbsp;related to replication if we are upgrading th=
e &nbsp;PG slave host first ,&nbsp; ?</p>
<p><br>
</p>
<p>Thank you</p>
<p><span id=3D"ms-rterangepaste-end">Isabella</span><br>
</p>
</body>
</html>

--_000_154047921571882040nrccnrcgcca_--




From johannes@truschnigg.info Thu Oct  25 18:07:30 2018
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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFk2x-0003kk-Vb
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 18:07:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gFk2u-00045e-FN
	for pgsql-admin@arkaria.postgresql.org; Thu, 25 Oct 2018 18:07:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <johannes@truschnigg.info>)
	id 1gFk2u-000459-10
	for pgsql-admin@lists.postgresql.org; Thu, 25 Oct 2018 18:07:48 +0000
Received: from truschnigg.info ([78.46.103.228])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <johannes@truschnigg.info>)
	id 1gFk2m-0004J1-NV
	for pgsql-admin@postgresql.org; Thu, 25 Oct 2018 18:07:47 +0000
Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at
 [84.112.34.152])
	(Authenticated sender: colo)
	by truschnigg.info (Postfix) with ESMTPSA id 1748340212;
	Thu, 25 Oct 2018 20:07:38 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info;
	s=mail; t=1540490859;
	bh=H13LsmR2zUfxoY2hnPJSeZZAddZa1CIfnSJpusSU63I=;
	h=Date:From:To:Cc:Subject:References:In-Reply-To:From;
	b=aHVaiAZx5yLiy776EPTP3p6k1X/Hh87RqEXtIU8xUINnnvVL/eRPtWOQnZ/K+9y0Y
	 D+YZefuiribgzwrxF/vLh7568/d6vAyA6GhHFAVk+wvbo7hfih91EAe8zOUQbvh7Gu
	 /w9thk6Hy4anz5ZMf5TXWVQ3RL87pPeRoOMSbVeE=
Date: Thu, 25 Oct 2018 20:07:30 +0200
From: Johannes Truschnigg <johannes@truschnigg.info>
To: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: upgrade slave  in streaming replication from PG 10.4 to 10.5.1
Message-ID: <20181025180729.xoharwuuytno5b7j@vault.lan>
References: <1540479215718.82040@nrc-cnrc.gc.ca>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="b3542bj2is35tgcd"
Content-Disposition: inline
In-Reply-To: <1540479215718.82040@nrc-cnrc.gc.ca>
User-Agent: NeoMutt/20170113 (1.7.2)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk


--b3542bj2is35tgcd
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi Isabella,

On Thu, Oct 25, 2018 at 02:53:35PM +0000, Ghiurea, Isabella wrote:
> Gmorning List,
>=20
> we have a system running  PG streaming replication using repmgr4 , PG hos=
ts
> are running Cent OS 7 with  PG 10.4, we have a request to upgrade to PG 1=
0.5
> , my plan is to upgrade the slave db host first and later on /next month
> switch over and upgrade the existing PG master, we are using the following
> PG extensions: citext , pg_sphere,pg_stat_statements,pgrowlocks.

Your question reads to me as if you somehow missed the important change in
pg's version numbering scheme that 10.0 introduced: These days, 10.n to 10.=
n+1
is not considered a major release upgrade (of the sort that requires
pg_upgrade or dump+restore, etc.) any more; it's what (e.g.) 9.6.n to 9.6.n=
+1
used to be. Therefore, both versions you mentioned should be compatible and
allow physical replication between themselves, no matter if the master or t=
he
slave are on the newer (minor) version than the other.

> Also in existing PG 10.4 cfg:/data/ pg_wal is a link  and we have cfg
> multiple tablespaces

Shouldn't matter, if your existing configuration works. Just install the ne=
w,
upgraded binaries, restart your service(s), and you should be good to go.

Personally, I'd upgrade the slave first- if anything goes awry (very unlike=
ly,
but accidents happen!), you don't have to fail over that way.

> Are any issues   related to replication if we are upgrading the  PG slave=
 host first ,  ?

Not in this scenario - if you were doing an actual major release upgrade (1=
0.x
to 11.x or later), you'd have to get more creative and (probably - there are
options, if you cannot afford that kind of interruption, but they are a bit
more involved) break replication for a while. If it comes to that, I'm sure
someone the list will be able to help out.

Cheers, and best of luck with your upgrade procedure!

--=20
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )

www:   https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp:  johannes@truschnigg.info

Please do not bother me with HTML-email or attachments. Thank you.

--b3542bj2is35tgcd
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAlvSBl4ACgkQ95W3jMsY
fLX7dA/7BxZRaekJYcGewnjPT71mUbBzKbc2zLXdO7ruQqvKXkrt2EDmmovPtSkW
XZuMxIDJN7c1oP/UJ99uj57TG6VYBlVv2G9T7WHD74Dpq2/WYzJ+LunNFr51aizg
HfF+II+8vAS4S8LqIy/oxthyX7OzmEsa3R7On+H71jLihrGIsL6qfPq318TVSeld
vWoq9NrZkRdf1/7MhpJ/sHpOL3c33MOTLK4PlQbm7DgykoGvkctdAcIiKe8pF9zm
y9wZTUZfVx+g68nExjXcQbG4JvULXOye6WLhZlrhb5RytSmh4CkV+XRZvr11zAfd
bEYUepuG/Hsv+LtuZDl4MGSpjkMdmdSt8b/gbJLO6P0ZVUsicwCRqmO5C4CCC1TU
1O7LM3tAgkObnj0XT2RJx0jgvpTz/d/eveL7xulYsz58o99YdP3NFSzPE/lDTKwa
G0h9QkHxp9JCjJQzBReTRMe44/C8qx2/CuSDQ4qwmX/CKaGMpHG6zhtsoFeuZSVl
nvcxXkGWdIfsWdJcg5I1u9uT4LtwdtbV5pfDdR1fpPSaAGfUBqWNGUa3YF+iM/qK
EVZFlJrBB4d77OoQTeWJNq7EoxR8Bwwz23ecY0m4n4zHU8HmdEnVUgqCBP1puSKW
SKSQJNw/HwmIY4JcmdBiWj5c9u9zU5LEAkpjkQJWnSG8Js2n4u8=
=gDph
-----END PGP SIGNATURE-----

--b3542bj2is35tgcd--