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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, "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:47:47
Message-ID: 0A8FE679886142EBABB0AC8102477904@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

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