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

From Andrus
Subject Re: How to prevent master server crash if hot standby stops
Date
Msg-id 0A8FE679886142EBABB0AC8102477904@dell2
Whole thread Raw
In response to Re: How to prevent master server crash if hot standby stops  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: How to prevent master server crash if hot standby stops
List 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.



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Server with hot standby slave wont start after vacuum
Next
From: "Andrus"
Date:
Subject: Re: How to prevent master server crash if hot standby stops