Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTUn2-0002tP-DM for pgsql-admin@arkaria.postgresql.org; Thu, 14 Jun 2018 16:08:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTUn0-0000UO-MX for pgsql-admin@arkaria.postgresql.org; Thu, 14 Jun 2018 16:07:58 +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 ) id 1fTUn0-0000UB-8x for pgsql-admin@lists.postgresql.org; Thu, 14 Jun 2018 16:07:58 +0000 Received: from mr28p48im-tydg10113601.me.com ([17.110.88.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTUmw-0001h3-Tm for pgsql-admin@lists.postgresql.org; Thu, 14 Jun 2018 16:07:57 +0000 Received: from process-dkim-sign-daemon.mr28p48im-tydg10113601.me.com by mr28p48im-tydg10113601.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) id <0PAB00M00M4PB400@mr28p48im-tydg10113601.me.com> for pgsql-admin@lists.postgresql.org; Thu, 14 Jun 2018 16:07:52 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=04042017; t=1528992472; bh=0r0B0CX53WDqrf2AgYp8IZ2LN+1xjb7wc5VjdPEiSJI=; h=Content-type:MIME-version:Subject:From:Date:Message-id:To; b=yHF9x6Wky93IcLZfCOfbaqqdpj/pB+TUSc1U3t6BpV4XNgYMB90DHMS6WYnlEPz2a 3gtZd7lAmyrixX7yudlrNdmMwcr1LO6EB/qpaU0s1sw3NrinU00q2l2FiwBoOL5aGr 5sJ4qfVYWiX+s1CQKle/8a6hKrWUS8CgPmdR3WzWH+I4USMWfCuaII0qtJLqs5i1o0 6q6FM4luR/nxMknnbMDUjTUlIyDtGiFzsdCKbVXzlttw3BsnNrLPUYSLsopjpbhGQj iJyXKGOh849jtoT/aMgG8yN6P63jLS4IVw/GibVjh4MGhS9iGEUEKPNZuihZRSeUwY 0pJWcu1+JCxWg== Received: from icloud.com ([127.0.0.1]) by mr28p48im-tydg10113601.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) with ESMTPSA id <0PAB00CR7M4YFV40@mr28p48im-tydg10113601.me.com>; Thu, 14 Jun 2018 16:07:50 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-06-14_06:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 clxscore=1015 suspectscore=0 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1707230000 definitions=main-1806140177 Content-type: text/plain; charset=us-ascii MIME-version: 1.0 (Mac OS X Mail 11.4 \(3445.8.2\)) Subject: Re: Stopping writes in master From: Rui DeSousa In-reply-to: <773C842E-0684-424D-B7A0-E24264A87495@icloud.com> Date: Thu, 14 Jun 2018 12:07:46 -0400 Cc: Shreeyansh Dba , Robert Zenz , pgsql-admin@lists.postgresql.org Content-transfer-encoding: quoted-printable Message-id: References: <5B224C42.6060107@sibvisions.com> <773C842E-0684-424D-B7A0-E24264A87495@icloud.com> To: Debraj Manna X-Mailer: Apple Mail (2.3445.8.2) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.=