You’d Better Have Tested Backups

You'd Better Have Tested Backups...

PostgreSQL Conference Europe, 2014

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapoueh

Oct 22,2014

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 1 / 36

Dimitri Fontaine

2ndQuadrant France PostgreSQL Major Contributor

? pgloader ? prefix, skytools ? apt. ? CREATE EXTENSION ? CREATE EVENT TRIGGER ? Bi-Directional R?eplication ? pginstall

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 2 / 36

You'd Better Have Tested Backups...

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 3 / 36

In fact, backups are not interesting

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 4 / 36

Actually, automated recovery testing

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 5 / 36

Use a battle tested tool

WHY USE BARMAN? Barman: disaster recovery for business critical PostgreSQL databases

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 6 / 36

Today we're talking about what happens when you don't

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 7 / 36

Backups? we have a shell script!

Dimitri Fontaine dimitri@2ndQuadrant.fr @tapYoouue'hd Better Have Tested Backups...

Oct 22,2014 8 / 36

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download