Bug 1504999 - [RFE] Replication slot monitoring
Summary: [RFE] Replication slot monitoring
Keywords:
Status: CLOSED DUPLICATE of bug 1445291
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Replication
Version: 5.8.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: 5.8.3
Assignee: Gregg Tanzillo
QA Contact: Dave Johnson
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-10-20 22:33 UTC by Nick Carboni
Modified: 2017-11-13 19:08 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-11-13 19:08:41 UTC
Category: ---
Cloudforms Team: CFME Core
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Nick Carboni 2017-10-20 22:33:13 UTC
Description of problem:
It is possible that a situation occurs when a replication slot is not being consumed from. This causes WAL log to accumulate on the database server which will eventually lead to the database filesystem filling up and system failure.

This is something we can monitor from the application and ideally send an alert or notification so the admin can fix the situation.

In more detail, we will want to check that the 'active' column of the pg_replication_slots table is always 'true'. When a slot is not being consumed from, it becomes inactive and this is a precursor to disk usage issues.

Comment 2 Nick Carboni 2017-11-13 19:08:41 UTC
oops

*** This bug has been marked as a duplicate of bug 1445291 ***


Note You need to log in before you can comment on or make changes to this bug.