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 66DF84156F9442448FF8E8CF575FFE54@dell2
Whole thread Raw
In response to Re: How to prevent master server crash if hot standby stops  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Hi!

Thank you.

>When you use replication slots, it is very important to put in place a
>monitoring solution to check if too much WAL is retained, and note
>that there is nothing able to do that natively in core Postgres.
>There are however multiple ways to solve this problem, like a
>background worker (for the slot monitoring as well as optionally
>killing and/or dropping), a simple cron job or even check_postgres.

Where to find some sample how to implement this ?

I read from docs that slot cannot dropped if it is in use.
How to stop replication in this case.

Andrus.



pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to prevent master server crash if hot standby stops
Next
From: Jan Strube
Date:
Subject: AW: Out of memory in big transactions after upgrade to 12.2