Add PostgreSQL backup monitoring feature to PMM

Description

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

How to test

None

How to document

None

AFFECTED CS IDs

CS0050542

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

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.

, JFYI

Details

Assignee

Reporter

Priority

Labels

Needs QA

Yes

Needs Doc

Yes

Smart Checklist

Created October 23, 2024 at 7:27 AM
Updated November 6, 2024 at 2:01 PM

Flag notifications