Re: How to prevent master server crash if hot standby stops

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to prevent master server crash if hot standby stops
Дата
Msg-id 0A8FE679886142EBABB0AC8102477904@dell2
обсуждение исходный текст
Ответ на Re: How to prevent master server crash if hot standby stops  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: How to prevent master server crash if hot standby stops
Список pgsql-general
Hi!

Thank you.

>That's why you use monitoring.
>Never use replication slots without monitoring replication (or at least the
>disk space on the primary).

How to implement this automatically, without human interaction required ?

"superuser_reserved_connections" setting exists.
How about implementing    "data_reserved_space" setting ?

How to create procedure in server or maybe cron scipt which stops replication if disk becomes nearly full ?

How to force to stop replication slot in master if it is in use ?

Andrus.



В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Server with hot standby slave wont start after vacuum
Следующее
От: "Andrus"
Дата:
Сообщение: Re: How to prevent master server crash if hot standby stops