How to automate PostgreSQL 12 replication and failover with repmgr

Click for: original source

An article about using repmgr for Postgres replication failover. repmgr is an open-source toolset from 2ndQuadrant, a leading specialist in PostgreSQL-related technologies and services. The product is used to automate, enhance, and manage PostgreSQL streaming replication. By Sadequl Hussain.

In this two-part series, author will see how repmgr and its daemon repmgrd can automate the high-availability and failover of a three-node PostgreSQL 12 cluster.

The article is split in parts:

  • A Walk-through of the environment
  • Step 1: Installing PostgreSQL 12 in all nodes
  • Step 2: Configuring PostgreSQL in witness and primary node
  • Step 3: Installing repmgr in primary and standby nodes
  • Step 4: Creating repmgr database and user in the primary node
  • Step 5: Adding primary node PostgreSQL config parameter

… and more. You will get a very quick introduction to repmgr which provides an easy-to-use interface over the technology that is already built into PostgreSQL for setting up replication. Good read!

[Read More]

Tags distributed database performance