From Dev to prod, The ABC's of PostgreSQL backups

Strategic Backup with PostgreSQL
Schedule

Presented by:

A132ac116e12236a4f6ce9d74497e277

Scott Mead

AWS

Scott has been a PostgreSQL user, DBA, Developer & contributor for over 16 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.

Date:
2017 March 30 09:00 EDT
Duration:
50 min
Room:
America
Conference:
PGConf US 2017 [PgConf.US]
Language:
English
Track:
Operations
Difficulty:
Medium