Скачать или смотреть Unleash the Power within pgBackRest / Stefan Fercot (EDB)

This talk is recorded at PG Day’21 Russia - community recognised event that took place online on 8-9 July 2021.
PG Day’21 Russia is annual event that normally takes place in St Petersburg, Russia and focusses on PostgreSQL.

Subscribe to the mailing list on our website not to miss announcements about our next conference! https://pgday.ru/en/2021
-----
Unleash the Power within pgBackRest / Stefan Fercot
After a quick reminder of its basic functionalities, we'll go deeper with some less common operations: refresh a standby server, take backups from a standby, and setup asynchronous archiving. By doing so, we'll also have a look at the current implementation of the multi-repositories support feature introduced in the latest pgBackRest release.

You may already be familiar with the diagnostic and troubleshooting features of pgBackRest: `info` or other internal commands, and its logs. These are very useful to check the state of your backups, but are you sure the existing backups match the retention policy? Are you sure you have all the WAL archives you need to restore?

We'll finally discover `check_pgbackrest`: a (Nagios-compatible) monitoring tool to help you watch your backups and archives.

Slides: https://pgday.ru/presentation/297/60f...