Re: Stopping writes in master

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Re: Stopping writes in master
Дата
Msg-id CAF6DVKOxxOJgG36zKjqwCd8oNOLAqmpOxCFCMWs6Bs7owBVd8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Stopping writes in master  (Robert Zenz <robert.zenz@sibvisions.com>)
Ответы Re: Stopping writes in master  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Zenz
Дата:
Сообщение: Re: Stopping writes in master
Следующее
От: Wei Shan
Дата:
Сообщение: Re: BTree index support prefix compression