pgBackRest is a widely used open source backup tool that offers several capabilities, such as parallel backup, incremental and differential backup, and the ability to stream a backup to the cloud from both master and standby databases. This is very suitable for database environments that are several terabytes in size. In this recipe, we shall see the steps involved in installing pgBackRest on Red Hat or CentOS operating systems.
Getting ready
In order to install pgBackRest, the PGDG repository should be configured. Visit www.postgresql.org/downloads to download the appropriate PGDG repo for the Linux distribution. It requires internet connectivity to download the repository and the packages. Otherwise, the pgbackrest packages need to be downloaded to any other server that has internet connectivity and then copied to the database server.
How to do it
The following are the steps involved in installing pgBackRest on the CentOS/Red Hat family of...