pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PG   how to stop streaming replication( master host)
Date: Fri, 14 Dec 2018 22:58:46 +0000
Message-ID: <1544828326249.49231@nrc-cnrc.gc.ca> (raw)
In-Reply-To: <SN6PR11MB2976E78D06B066CCAC7C5F7DA7A10@SN6PR11MB2976.namprd11.prod.outlook.com>
References: <1544827614785.42348@nrc-cnrc.gc.ca>
	<SN6PR11MB2976E78D06B066CCAC7C5F7DA7A10@SN6PR11MB2976.namprd11.prod.outlook.com>

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 backup 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 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 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 performance of insert   .



________________________________
From: Scott Whitney <scott@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 slaves.

https://coderwall.com/p/nirwxa/pause-and-resume-hot_standby-replication-on-postgres-database
________________________________
From: Ghiurea, Isabella <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  options to stop replication ( no just  pause /resume  the WAL'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



[http://journyx.com/emailImages/ScottWhitney.png]

[http://journyx.com/emailImages/linkedin.png]<https://www.linkedin.com/company/journyx-inc/;  [http://journyx.com/emailImages/twitter.png] <https://www.twitter.com/journyxinc;
        [http://journyx.com/emailImages/bluebar.jpg]

Scott Whitney
Director of IT

[http://journyx.com/emailImages/journyx.jpg]

scott@journyx.com<mailto:scott@journyx.com> | +1 (800) 755-9878

7600 Burnet Road, Ste. 300
Austin, TX 78757

Visit us at www.journyx.com<https://www.journyx.com/;



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

view thread (6+ messages)  latest in thread

Message-ID: <1544828326249.49231@nrc-cnrc.gc.ca>
Permalink:  ../1544828326249.49231@nrc-cnrc.gc.ca/
Also on:    postgresql.org/message-id/1544828326249.49231@nrc-cnrc.gc.ca

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Isabella.Ghiurea@nrc-cnrc.gc.ca
  Subject: Re: PG   how to stop streaming replication( master host)
  In-Reply-To: <1544828326249.49231@nrc-cnrc.gc.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox