PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Magnus Hagander
Day Talks - Day 1 - 2017-05-25
Room DMS 1160
Start time 15:00
Duration 00:45
ID 1043
Event type Lecture
Track DBA

PostgreSQL backups the modern way

There have been many different ways to take backups of PostgreSQL systems over the years, and the tools to do so have evolved both inside PostgreSQL and as addons.

Are you using pgdump for backups? Calling pgstartbackup()? Writing an archivecommand? Then you're probably missing out on new features, and possibly even risking your backups.

In this talk we'll go through the "right" way to do backups on modern versions of PostgreSQL, both using builtin tools and proven external utilities.