Скачать или смотреть Stefan Fercot: What can't pgBackRest do for you? (PGConf.EU 2023)

pgBackRest, the powerful backup and restore tool for PostgreSQL, has been widely embraced by the community for its robustness and efficiency. However, every tool has its limitations, and pgBackRest is no exception.

One area that begs for further exploration is its archiving system, which plays a vital role in enabling Point-in-Time Recovery (PITR). During this session, we will embark on a journey to uncover the missing features in this area and delve into the innovative solutions provided to enhance PostgreSQL WAL archiving effectiveness.

While taking a backup might sound easy, restoring it to reach a specific target isn't that obvious. We will then explore the challenges faced by users and database administrators to achieve a successful recovery.

The talk will be focused on three main areas:

Archiving Configuration: Analysis of the current archiving possibilities and their limitations Optimizing archiving performance by leveraging parallelism and various compression algorithms

Improved Monitoring and Reporting: The importance of monitoring and reporting the backups and archiving system state Analysis of the existing monitoring and troubleshooting capabilities in pgBackRest Suggestions for enhanced metrics and alerts

Advanced Point-in-Time Recovery (PITR) Capabilities: Analysis of the current restore options in pgBackRest, introducing additional granularity to reach specific recovery targets Leveraging advanced recovery techniques for partial data restoration

By attending this talk, participants will gain valuable insights into some limitations of pgBackRest and learn about potential solutions to fill the gaps. Whether you are an experienced PostgreSQL user, a database administrator, or an enthusiast exploring backup and restore options, this session will provide you with a fresh perspective to enhance your PostgreSQL data protection strategy.