PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Speakers
Josh Berkus
Schedule
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Monpetit 202
Start time 15:15
Duration 00:45
Info
ID 662
Event type Lecture
Track DBA
Language used for presentation English

HowTo DR

planning for the worst

There's a lot more to disaster recovery than making backups. Most of DR, in fact, is planning instead of code: knowing what you need to do when disaster strikes, how to do it, and who does it. Further complicating things, management and admins are fond of preparing for unlikely events while failing to prepare for probable outages at all.

There's a lot more to disaster recovery than making backups. Most of DR, in fact, is planning instead of code: knowing what you need to do when disaster strikes, how to do it, and who does it. Further complicating things, management and admins are fond of preparing for unlikely events while failing to prepare for probable outages at all. This talk will outline how to make a disaster recovery plan, and some basic dos and don'ts of DR. Included:

The three most common downtime causes
Determining acceptable losses (and getting management to agree)
Backup vs. Replication
Planning for the unexpected
Against Improvising (always have a Plan B)
Public Cloud DR
Other Dos and Don'ts

When disaster strikes, it's too late to start planning. Do it now.