Content:

PostgreSQL backups

• Backups using pg_dump
• Recovery using pg_restore

The PostgreSQL I/O system

• I/O cache (shared buffers)
• Storage files and tablespaces
• The PostgreSQL transaction log (WAL)
• The background writer
• Checkpoints

Point-In-Time recovery

• Archiving the transaction log
• Replaying transaction log

Asynchronous replication

• Master / slave replication
• Transaction log streaming / streaming replication

Synchronous replication

• Building a synchronous cluster
• Performance optimization

Complex setups

• Combining synchronous and asynchronous replication

External tools

• repmgr
• skytools

Logical replication

• londiste replication
• Upgrading PostgreSQL with londiste

High-availability

• Concepts