Add PostgreSQL backup monitoring feature to PMM
Description
How to test
How to document
AFFECTED CS IDs
Activity
Roma Novikov November 6, 2024 at 2:01 PM
It looks like there is already a solution for this https://github.com/woblerr/pgbackrest_exporter we can try to use
Aaditya Dubey November 5, 2024 at 7:19 AM
Hi @Lalit Choudhary
Thank you for the report and feedback.
Tibor Korocz (Percona) October 23, 2024 at 2:05 PM
Yes, anyone can add any additional metrics through TextFileCollector from any script.. we did the same in GAS team, we had our own backup solution and that was creating Textfiles for PMM to read.. and we had alerts based on those..
They are trying to use some external backups script ? Or they are using a backup solution what we provided?
Roma Novikov October 23, 2024 at 12:56 PM
Per the original request from the customer (what I’m reading from SN), it was more about “monitoring their Backup Tool “ and warning when there are some errors happening.
The user is using pgbackrest and wants to know when there will be an error from it.
Theoretically, it can be some additional TextFileCollector approach to expose errors and scrape them to PMM.
@Tibor Korocz (Percona) , @Charly Batista JFYI
Details
Assignee
UnassignedUnassignedReporter
Lalit ChoudharyLalit ChoudharyPriority
MediumLabels
Needs QA
YesNeeds Doc
Yes
Details
Details
Assignee
Reporter
Priority
Labels
Needs QA
Needs Doc
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

It will be useful if PMM can monitor/show PostgreSQL backups information.