PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Jose Luis Tallon
Day Tutorials & Unconference - Day 2 - Wednesday - 2015-06-17
Room DMS 1140
Start time 09:00
Duration 03:00
ID 867
Event type Workshop
Track Tutorial
Language used for presentation English

Business Continuity, High Availability and Disaster Recovery

Blueprints, validated architectures and implementation tips for HA / DR / BC

Having run Postgres reliably for years does not automatically exempt anyone from eventually having some data loss incident.

Even when PostgreSQL is one of the more robust and resilient databases, disaster can still strike. When ensuring that some incident will not kill the business is your responsibility, preparation is key.

This tutorial covers Business Continuity topics, focusing on the techniques needed to achieve adequate availability (HA) as well as prepare for disaster recovery (DR) should something happened to your database. We will describe the evolution from a stand-alone database to a fully replicated, distributed setup as well as several specific techniques to increase recoverability using some features from PostgreSQL 9.4. Backup and recovery techniques will be reviewed and evaluated in terms of RPO/RTO objectives and the associated tradeoffs.

The session will close with an open scenario/interactive round of questions where specific use cases will be analyzed and solutions will be suggested.