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