April 2015
Intermediate to advanced
504 pages
11h 41m
English
This recipe describes how to set up a hot physical backup with a continuous archiving mechanism. The purpose of continuous archiving is to allow us to recover to any point in time from the time of the backup.
Manually performing each step of this procedure is a great way to gain a clear understanding of PostgreSQL's backup and restore infrastructure. However, to reduce the chances of human errors, it is best practice to avoid reliance on complex activities that must be performed by a human operator. Procedures such as taking a hot physical backup or restoring it up to a given point in time are at least automated with custom scripts, and normally it is preferable to use a third-party, specialized ...