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]