Re: How to prevent master server crash if hot standby stops - Mailing list pgsql-general

From Laurenz Albe
Subject Re: How to prevent master server crash if hot standby stops
Date
Msg-id b23afcd4f436c3310f236086b9daa39304650874.camel@cybertec.at
Whole thread Raw
In response to How to prevent master server crash if hot standby stops  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: How to prevent master server crash if hot standby stops
List 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 by date:

Previous
From: "Andrus"
Date:
Subject: How to prevent master server crash if hot standby stops
Next
From: Michael Paquier
Date:
Subject: Re: How to prevent master server crash if hot standby stops