Re: Stopping writes in master

Hi Debraj Manna,

Yes,You can make the database read only as well just by setting the below
parameter is equal to true at the session level.But you need reconnect your
existing connections.

ALTER DATABASE YOUR_DATABASE_NAME SET default_transaction_read_only = true;

Hope this helps..

<http://www.shreeyansh.com>

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

> 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(dot)zenz(at)sibvisions(dot)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,
>> >
>
>