Chapter 7. Working with Third-Party Replication Management Utilities

In this chapter, we will cover the following:

  • Setting up Barman
  • Backup and recovery using Barman
  • Setting up OmniPITR
  • WAL management with OmniPITR
  • Setting up Repmgr
  • Using Repmgr to create Replica
  • Setting up Walctl
  • Using Walctl to create Replica

Introduction

Indexes are in essence a database structure that speeds up fetching the data access operations. Indexes are basically used to boost database performance by rapidly locating data without having to search every row in the database table every time it is accessed. Data access via indexes is known as an indexed scan and it is used to provide random lookups and organized access of ordered records. In this chapter, we are going to talk about ...

Get PostgreSQL High Performance Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.