O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting up OmniPITR

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.

Getting ready

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.

How to do it...

The following are the series of steps that are required to configure and install OmniPITR:

  1. On both the master and slave machines we can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required