Schedule - PGConf.EU 2013Doing PITR Right - There's more than just replication
Date: 2013-10-31
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! SpeakerStephen Frost |