Session

Back

#5 - Practical PostgreSQL Backup & Restore (PM)

Date: 2017-09-06
Time: 13:30 - 16:30
Room: Stockton
Level: Intermediate

Reliable backup and restore is must for any production PostgreSQL environment. Too often this important topic is left as an afterthought and important data is lost.

The training will cover the built-in PostgreSQL backups tools, pg_dump and pg_basebackup, and show their proper usage to get consistent backups and restores.

While it's important to understand usage of the built-in tools, they may not be practical because they require a lot of scripting to implement the features that are commonly required, such as WAL archiving, backup/WAL expiration, and monitoring.

Therefore, the training will also cover pgBackRest in depth. This enterprise-class tool implements a complete out-of-the-box solution for PostgreSQL backup and addresses many of the limitations of pg_dump and pg_basebackup.

The ultimate goal of the training is to enable attendees to confidently configure a robust backup and restore solution for PostgreSQL in their enterprise.

Speaker

David Steele