Schedule - PGConf.EU 2013

Doing PITR Right - There's more than just replication

Date: 2013-10-31
Time: 10:50–11:40
Room: Earlsfort
Level: Beginner

Is your data important? If so, it needs to be backed up and by far the best way to do that is with Point-in-Time Recovery. This talk will cover the current 'state of the art' regarding PostgreSQL backup, restore, and PITR. We'll bring a database up, throw some data into it, back it up, add some more data, delete some data, then show how to restore up to the point before the data was deleted.

In this talk, we'll also cover how PostgreSQL writes out data and how that stream allows us to create a backup which can be used to go back to any point in time during the database's operation. Understanding this is critical to any production database because when you need to do a restore, you don't want to go back to yesterday's backup and lose all the work that happened today!

Speaker

Stephen Frost

Platinum Sponsors

2ndQuadrant
EnterpriseDB

Gold Sponsors

Cybertec
Heroku

Silver Sponsors

Dalibo
Gilt
VMware
Zalando
EngineYard
Servoy
Vertabelo