May 2018
Intermediate to advanced
576 pages
30h 25m
English
The following table shows the features available, depending on the backup technique selected. The details of these techniques are covered in the remaining recipes in this chapter:
| SQL dump to an archive file: pg_dump -F c | SQL dump to a script file: pg_dump -F p or pg_dumpall | Filesystem backup using: pg_start_backup | |
| Backup type | Logical | Logical | Physical |
| Recover to point in time | No | No | Yes |
| Zero data loss | No | No | Yes (see note 6) |
| Back up all databases | One at a time | Yes (pg_dumpall) | Yes |
| All databases backed up at the same time | No | No | Yes |
| Selective backup | Yes | Yes | No (see note 2) |
| Incremental backup | No | No | Possible (see note 3) |
| Selective restore | Yes | Possible (see note 1) | No (see note 4) |
| DROP TABLE recovery | Yes | Yes |