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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to prevent master server crash if hot standby stops
Date: 2020-04-06 08:27:05
Message-ID: b23afcd4f436c3310f236086b9daa39304650874.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2020-04-06 08:28:41 Re: How to prevent master server crash if hot standby stops
Previous Message Andrus 2020-04-06 08:03:20 How to prevent master server crash if hot standby stops