PostgreSQL Backup and Recovery

Kevin Kempter

From PostgreSQL Conference West Speakers

PostgreSQL Backup and Recovery This talk will cover the basics of a backup / recovery strategy, plus modules on Point in Time Recovery (PITR) and how to setup and failover a warm standby server. Topics Covered/TOC:

Overview
Backup Options
pg_dump
pg_dumpall
Restore Options
psql
pg_restore
TOC files
PITR
PITR setup
PITR Recovery
Warm Standby
Setup
Failover options
Failover example
AttachmentSize
backup-and-recovery2.pdf137.39 KB