PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
Speakers | |
---|---|
Magnus Hagander |
Schedule | |
---|---|
Day | Talks - Day 1 - 2017-05-25 |
Room | DMS 1160 |
Start time | 15:00 |
Duration | 00:45 |
Info | |
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.