Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

(pg17) monitor logical slot sync #398

Open
hunleyd opened this issue Mar 16, 2024 · 2 comments
Open

(pg17) monitor logical slot sync #398

hunleyd opened this issue Mar 16, 2024 · 2 comments
Labels
FEATURE New feature or request
Milestone
5.2

Comments

@hunleyd
Copy link
Collaborator

hunleyd commented Mar 16, 2024

Describe the enhancement you are proposing:

pg_replication_slot is changed in pg17 to show if logical slots are in sync or not. would be nice to have a metric around that. see this blog.
@hunleyd hunleyd added the UNCONFIRMED Initial state. Need's triaged label Mar 16, 2024
@keithf4 keithf4 added this to the Future milestone May 15, 2024
@keithf4
Copy link
Collaborator

keithf4 commented May 17, 2024

Will review this once PG17 is released and the full feature set of this has been finalized and documented.

Right now, hard to tell if the synced column is something that will periodically change and may be false for periods of time while the slot info is being updated. Might need to have a bit of a delay on this as an alert.

@keithf4 keithf4 added NEED INFO Need's more information from reporter (if ISSUE) or the Crunchy HA Team (if PR) and removed UNCONFIRMED Initial state. Need's triaged labels May 17, 2024
@keithf4 keithf4 added FEATURE New feature or request and removed NEED INFO Need's more information from reporter (if ISSUE) or the Crunchy HA Team (if PR) labels Jan 10, 2025
@keithf4 keithf4 modified the milestones: Future, 5.2 Jan 10, 2025
@keithf4
Copy link
Collaborator

keithf4 commented Jan 10, 2025 •
edited
Loading

Will definitely have the new metrics for this in for 5.2. Need to do some further investigation to how the failover and synced columns actually work to make a sane alert for them. But at least they'll be there if someone else wants to try and do that too. Added some additional other slot related metrics too

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
FEATURE New feature or request
Projects
None yet
Milestone
5.2
Development

No branches or pull requests
2 participants
@keithf4 @hunleyd