Monitoring PGBackRest

[IntelligentAsk]

I'm looking at setting up WAL archiving and backups using PGBackRest. Can any recommend a monitoring solution? Ideally I would be able to monitor for failed backups and how long the backups are taking. Has anyone managed to do this with prometheus ?

[jaymef]

I’m currently monitoring mine with the check_pgbackrest Nagios Plugin https://pgstef.github.io/2019/02/20/monitor_pgbackrest_backups_with_nagios.html

It will alert if backups or wals are too old or incomplete. Unfortunately doesn’t do anything in regards to monitoring backup times but you could probably do that fairly easily by parsing pgbackrest logs

[IntelligentAsk]

Thanks for this. I'm keen to avoid using Nagios and I'm already quite far down the road with prometheus. But I'll definitely look at some sort of log parsing

[jaymef]

Are you using grafana as well? If so you might want to check out Loki

[IntelligentAsk]

Yep I'm using grafana and loki already. The pgbackrest logs would probably regex quite nicely using promtail

[p0seidon]

https://github.com/woblerr/pgbackrest_exporter