Postgres Pro
Downloads
Home   >   mailing lists

Re: Stopping writes in master - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Stopping writes in master
Date
Msg-id CAGDYbUOMA_tTwVHW5RqtV-s-VJeaQqAMc32uV4H7A01Ge4DFPQ@mail.gmail.com
Whole thread Raw
In response to Stopping writes in master  (Debraj Manna <subharaj.manna@gmail.com>)
List pgsql-admin
Tree view
Hi Debraj Manna,

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

Hope this helps..



On Thu, Jun 14, 2018 at 4:16 PM, Debraj Manna <subharaj.manna@gmail.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,


pgsql-admin by date:

Previous
From: Debraj Manna
Date:
Subject: Stopping writes in master
Next
From: Robert Zenz
Date:
Subject: Re: Stopping writes in master