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_--