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 ) id 1gXwQ6-00058F-GS for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 22:58:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gXwQ4-00032I-R1 for pgsql-admin@arkaria.postgresql.org; Fri, 14 Dec 2018 22:58:56 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gXwQ4-000328-JU for pgsql-admin@lists.postgresql.org; Fri, 14 Dec 2018 22:58:56 +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 ) id 1gXwQ0-0003pg-Ga for pgsql-admin@postgresql.org; Fri, 14 Dec 2018 22:58:55 +0000 Received: from DC01ZWH0021.corp.nrc.gc.ca ([167.37.58.17]) by mx.ssan.egs-seg.gc.ca with ESMTP id wBEMwkjq026352-wBEMwkjs026352 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=CAFAIL) for ; Fri, 14 Dec 2018 17:58:46 -0500 Received: from DC01ZWH0016.Corp.nrc.gc.ca (167.37.54.210) 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:58:43 -0500 Received: from DC01ZWH0014.Corp.nrc.gc.ca (167.37.54.208) by DC01ZWH0016.Corp.nrc.gc.ca (167.37.54.210) with Microsoft SMTP Server (TLS) id 15.0.1347.2; Fri, 14 Dec 2018 17:58:46 -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:58:46 -0500 From: "Ghiurea, Isabella" To: "pgsql-admin@postgresql.org" Subject: Re: PG how to stop streaming replication( master host) Thread-Topic: PG how to stop streaming replication( master host) Thread-Index: AQHUk/7pBpagDXIC0Eq6FL2B4a9q6aV+1tYzgAAAXj0= Date: Fri, 14 Dec 2018 22:58:46 +0000 Message-ID: <1544828326249.49231@nrc-cnrc.gc.ca> References: <1544827614785.42348@nrc-cnrc.gc.ca>, In-Reply-To: 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_154482832624949231nrccnrcgcca_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_154482832624949231nrccnrcgcca_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you Scott, this will only pause the WAL's . if you have a lot of activity happening in master while slave db is been b= ackup this can fail behind a lot and eventually can fill up /wal directory.= I also use the option you mentioned , but I was looking for an option to a= ctually disable the replication at master host completely since I must in= sert 200GB of content in db and next I can re-enable replication using re= sync slave with master ( pg_restore). I am trying to have the replication= disabled while I am loading that amount of data to not affect the perform= ance of insert . ________________________________ From: Scott Whitney Sent: Friday, December 14, 2018 2:50 PM To: pgsql-admin@postgresql.org; Ghiurea, Isabella Subject: Re: PG how to stop streaming replication( master host) I use this during my backups to have a consistent state on my multiple slav= es. https://coderwall.com/p/nirwxa/pause-and-resume-hot_standby-replication-on-= postgres-database ________________________________ From: Ghiurea, Isabella Sent: Friday, December 14, 2018 4:46:55 PM To: pgsql-admin@postgresql.org Subject: PG how to stop streaming replication( master host) 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 [http://journyx.com/emailImages/ScottWhitney.png] [http://journyx.com/emailImages/linkedin.png] [http://journyx.com/emailImages/twitter.png] [http://journyx.com/emailImages/bluebar.jpg] Scott Whitney Director of IT [http://journyx.com/emailImages/journyx.jpg] scott@journyx.com | +1 (800) 755-9878 7600 Burnet Road, Ste. 300 Austin, TX 78757 Visit us at www.journyx.com To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-pr= eferences. --_000_154482832624949231nrccnrcgcca_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Thank you Scott, this will only pause the WAL's  .

if you have a lot of activity happening in master while slave  db i= s been backup this can fail behind a lot and eventually can fill up /wal di= rectory. I also use the option you mentioned , but I was looking for an opt= ion to actually disable the replication at master  host completely  since I must insert 200GB of content= in db and  next I can re-enable replication using  resync s= lave with master ( pg_restore). I  am trying to have  the replica= tion disabled while I am loading that amount of data to not affect  the performance of insert   .



From: Scott Whitney <s= cott@journyx.com>
Sent: Friday, December 14, 2018 2:50 PM
To: pgsql-admin@postgresql.org; Ghiurea, Isabella
Subject: Re: PG how to stop streaming replication( master host)
 
I use this during my backups to have a consistent state on my multiple slav= es.

From: Ghiurea, Isabella &= lt;Isabella.Ghiurea@nrc-cnrc.gc.ca>
Sent: Friday, December 14, 2018 4:46:55 PM
To: pgsql-admin@postgresql.org
Subject: PG how to stop streaming replication( master host)
 

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&= nbsp; options to stop replication ( no just  pause /resume  the W= AL's) master to slave without  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



&= nbsp;

Scott Whitney Director of IT

scott@journyx.com | +1 (800) 755-9878

7600 Burnet Road, Ste. 300
Austin, TX 78757

Visit us at www.journyx.com


To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.
--_000_154482832624949231nrccnrcgcca_--