From Dev to prod, The ABC's of PostgreSQL backups
Scott has been a PostgreSQL user, DBA, Developer & contributor for over 12 years. His focus is on production, his goal is to design systems allow for "always-on" maintenance and carrier-grade reliability.
Most deployments of PostgreSQL start with a developer and a good idea. The good idea spreads and before you know it, you have a production system on your hands. We will cover the ABC's of PostgreSQL backups:
- Logical Backups
- Physical Backups
- Incremental / Differential Backups
- Optimizing for space
- Available tools
The trick is to leverage each of these in to a consistent strategy that allows you to meet the recovery and availability targets defined by the business.
- 50 min
- PGConf US 2017