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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How to prevent master server crash if hot standby stops
Дата
Msg-id b23afcd4f436c3310f236086b9daa39304650874.camel@cybertec.at
обсуждение исходный текст
Ответ на How to prevent master server crash if hot standby stops  ("Andrus" <kobruleht2@hot.ee>)
Ответы Re: How to prevent master server crash if hot standby stops
Список pgsql-general
On Mon, 2020-04-06 at 11:03 +0300, Andrus wrote:
> Streaming asynchronous binary replication is used with hot standby slave.
> 
> If slave stops responing, master server will create files in pg_wal directory.
> If disk becomes full, master server crashes also.
> 
> How to avoid this ?
> 
> If disk is nearly full, master should stop additional files creation (and maybe stop or disable replication slot).
> Postgres 12 in Debian 10 is used.

That's why you use monitoring.

Never use replication slots without monitoring replication (or at least the
disk space on the primary).

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: "Andrus"
Дата:
Сообщение: How to prevent master server crash if hot standby stops
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: How to prevent master server crash if hot standby stops