add alerts for pgbackrest (team#40950)

Embarrassed to admit there's no unit tests here, but i don't exactly know what those errors will even look like, lots of this is somewhat guessing. I did write real pager playbooks though.