Re: Stopping writes in master

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Stopping writes in master
Date: 2018-06-14 11:01:14
Message-ID: CAGDYbUOMA_tTwVHW5RqtV-s-VJeaQqAMc32uV4H7A01Ge4DFPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Debraj Manna,

You have to make your client as read only so that client can not write
on the master.

Hope this helps..

<http://www.shreeyansh.com>

On Thu, Jun 14, 2018 at 4:16 PM, Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
wrote:

> Hi
>
> In a 3 node cluster with 1 master and 2 slaves with postgres 10.4 is there
> any configuration setting that will stop all writes to the master from the
> client. But the clients can read data from master and other slaves ?
>
> Thanks,
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Zenz 2018-06-14 11:06:41 Re: Stopping writes in master
Previous Message Debraj Manna 2018-06-14 10:46:16 Stopping writes in master