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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Michael Paquier" <michael(at)paquier(dot)xyz>
Cc: "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:59:05
Message-ID: 66DF84156F9442448FF8E8CF575FFE54@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Strube 2020-04-06 12:12:52 AW: Out of memory in big transactions after upgrade to 12.2
Previous Message Andrus 2020-04-06 08:47:47 Re: How to prevent master server crash if hot standby stops