PostgreSQL Backup and Recovery

Talk Type: 
45 Minute Talk
Track: 
Administration
Technical Level: 
Beginner
License: 
BSD

We'll have a look at backup and recovery methods for PostgreSQL

Covered Topics:

- PostgreSQL pg_dump

- PostgreSQL pg_dumpall

- Restoring pg_dump files

- Restoring pg_dumpall files

- Customizing a restore via pg_dumpall TOC files

- PITR (Point In Time Recovery) Backups

- The PITR Recovery process