How to prevent master server crash if hot standby stops

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: How to prevent master server crash if hot standby stops
Date: 2020-04-06 08:03:20
Message-ID: 5E2C91B46CEF42078CC7BEE1EDC10F0E@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

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.

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-04-06 08:27:05 Re: How to prevent master server crash if hot standby stops
Previous Message Andrus 2020-04-06 06:39:34 Server with hot standby slave wont start after vacuum