Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gXwEd-0004i0-HI
	for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 22:47:07 +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 1gXwEc-0004bs-AK
	for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 22:47:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.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 1gXwEb-0004bl-W3
	for pgsql-admin@lists.postgresql.org; Fri, 14 Dec 2018 22:47:06 +0000
Received: from mx.ssan.egs-seg.gc.ca ([205.193.229.132])
	by makus.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 1gXwEX-0007K9-EX
	for pgsql-admin@postgresql.org; Fri, 14 Dec 2018 22:47:02 +0000
Received: from DC01ZWH0021.corp.nrc.gc.ca ([167.37.58.17])
	by mx.ssan.egs-seg.gc.ca  with ESMTP id wBEMktfg014087-wBEMktfi014087
	(version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=CAFAIL)
	for <pgsql-admin@postgresql.org>; Fri, 14 Dec 2018 17:46:55 -0500
Received: from DC01ZWH0012.Corp.nrc.gc.ca (167.37.54.206) by
 DC01ZWH0021.Corp.nrc.gc.ca (167.37.58.17) with Microsoft SMTP Server (TLS) id
 15.0.1347.2; Fri, 14 Dec 2018 17:46:51 -0500
Received: from DC01ZWH0014.Corp.nrc.gc.ca (167.37.54.208) by
 DC01ZWH0012.Corp.nrc.gc.ca (167.37.54.206) with Microsoft SMTP Server (TLS)
 id 15.0.1347.2; Fri, 14 Dec 2018 17:46:55 -0500
Received: from DC01ZWH0014.Corp.nrc.gc.ca ([167.37.54.208]) by
 DC01ZWH0014.Corp.nrc.gc.ca ([167.37.54.208]) with mapi id 15.00.1347.000;
 Fri, 14 Dec 2018 17:46:55 -0500
From: "Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: PG   how to stop streaming replication( master host)
Thread-Topic: PG   how to stop streaming replication( master host)
Thread-Index: AQHUk/7pBpagDXIC0Eq6FL2B4a9q6Q==
Date: Fri, 14 Dec 2018 22:46:55 +0000
Message-ID: <1544827614785.42348@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_154482761478542348nrccnrcgcca_"
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_154482761478542348nrccnrcgcca_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi List

I am running PGSLQ 10.4 with repmgr in synchronous streaming replication  2=
 servers: master+slave, I would like to learn if there are any  options to =
stop replication ( no just  pause /resume  the WAL's) master to slave witho=
ut  rebooting the master server  or the only option  is to take  the  Pg db=
 slave host down and eventually the  the /wal directory will get 100% full =
.


Isabella

--_000_154482761478542348nrccnrcgcca_
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>Hi List<br>
</p>
<p>I am running PGSLQ 10.4 with repmgr in synchronous streaming replication=
 &nbsp;2 servers: master&#43;slave, I would like to learn if there are any&=
nbsp; options to stop replication ( no just&nbsp; pause /resume &nbsp;the W=
AL's) master to slave without&nbsp; rebooting the master server&nbsp;
 or the only&nbsp;option&nbsp; is to take&nbsp; the &nbsp;Pg db slave host =
down and eventually the&nbsp; the /wal directory will get 100% full .</p>
<p><br>
</p>
<p>Isabella<br>
</p>
</body>
</html>

--_000_154482761478542348nrccnrcgcca_--