OmniPITR is a third-party tool that consists of a set of scripts that are used to maintain and manage PostgreSQL database transaction log files, that is, WAL logs.
OmniPITR can also be used for initiating hot backups on master and slave PostgreSQL servers.
In this recipe, we are going to set up and install OmniPITR.
In this recipe, we are going to show how to install OmniPITR on a machine. However, this needs to be done on both the master and slave servers. For our exercise, the
pg-primary serves as the master server and the
pg-clone server serves as the slave server.
The following are the series of steps that are required to configure and install OmniPITR: