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

From Debraj Manna
Subject Re: Stopping writes in master
Date
Msg-id CAF6DVKOxxOJgG36zKjqwCd8oNOLAqmpOxCFCMWs6Bs7owBVd8A@mail.gmail.com
Whole thread Raw
In response to Re: Stopping writes in master  (Robert Zenz <robert.zenz@sibvisions.com>)
Responses Re: Stopping writes in master
List pgsql-admin
Yes I want to switch the database to read-only mode. The existing connections should also be not able to write.

On Thu 14 Jun, 2018, 4:37 PM Robert Zenz, <robert.zenz@sibvisions.com> wrote:
Can existing connections be dropped or do they need to stay established? Also,
are you trying to switch the database to a read-only mode for backup purposes or
something different?


On 14.06.2018 12:46, Debraj Manna 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: Robert Zenz
Date:
Subject: Re: Stopping writes in master
Next
From: Wei Shan
Date:
Subject: Re: BTree index support prefix compression