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

help / color / mirror / Atom feed
From: Rui DeSousa <rui.desousa@icloud.com>
To: Debraj Manna <subharaj.manna@gmail.com>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Robert Zenz <robert.zenz@sibvisions.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Stopping writes in master
Date: Thu, 14 Jun 2018 12:07:46 -0400
Message-ID: <CEAD481F-7A61-4C42-AC24-2B4FA9EC4F19@icloud.com> (raw)
In-Reply-To: <773C842E-0684-424D-B7A0-E24264A87495@icloud.com>
References: <CAF6DVKMNN845W+MCRPXhJQH=a2-uBcKwktx7353a-fs4YR1OQg@mail.gmail.com>
	<5B224C42.6060107@sibvisions.com>
	<CAF6DVKOxxOJgG36zKjqwCd8oNOLAqmpOxCFCMWs6Bs7owBVd8A@mail.gmail.com>
	<CAGDYbUOPFgrJKtSaYO3Z71z3uYcp5mYG7ijQekL4J_cpwgCqUg@mail.gmail.com>
	<CAF6DVKOMGX41rV-P=1_o1j=18pq7buLXhK7jr5Y9pFoFc_6cxQ@mail.gmail.com>
	<773C842E-0684-424D-B7A0-E24264A87495@icloud.com>

Actually, I think the better option is just to reroute all your clients to one of the replias and leave the master as read/write.  It really going to depend on how you have HA setup.

It would be good to know that actual use case.



view thread (10+ messages)  latest in thread

Message-ID: <CEAD481F-7A61-4C42-AC24-2B4FA9EC4F19@icloud.com>
Permalink:  ../CEAD481F-7A61-4C42-AC24-2B4FA9EC4F19@icloud.com/
Also on:    postgresql.org/message-id/CEAD481F-7A61-4C42-AC24-2B4FA9EC4F19@icloud.com

 · 

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: rui.desousa@icloud.com, subharaj.manna@gmail.com, shreeyansh2014@gmail.com, robert.zenz@sibvisions.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Stopping writes in master
  In-Reply-To: <CEAD481F-7A61-4C42-AC24-2B4FA9EC4F19@icloud.com>

* 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