Part4 - PostgreSQL16 High Availability Lab Setup - Setting Up RepMGR16
Hi Everyone,
In Part 4 of our PostgreSQL 16 High Availability Lab Setup series, we focus on setting up repmgr 16, a robust tool for managing PostgreSQL replication and high availability. Follow along as we configure repmgr on your PostgreSQL 16 cluster, enabling efficient monitoring and management of your high availability setup.
What You'll Learn:
Installation and configuration of repmgr 16
Setting up replication and node management in a PostgreSQL 16 cluster
Best practices for ensuring high availability with repmgr
Don't forget to like, comment, and subscribe for more tutorials on PostgreSQL and high availability setups!
Chapters:
00:00 Intro
00:26 Get Network details and add it to Hosts file
02:16 Install RepMgr16 on 3 Nodes.
03:09 Create repmgr user in Postgres
04:32 add user to pg_hba.conf
05:57 Uncomment, a line in postgresql.conf file
07:02 Configure RepMgr on 3 nodes.
12:18 Register the Primary Node.
13:08 Registry the Secondary or Standby Nodes.
16:58 Configure ssh passwordless communication between Postgres nodes
21:40 Grant Postgres OS user Sudo privilege to control Postgres and repmgr systemd services
25:04 Enable the Repmgrd service and start it on 3 nodes.
Watch video Part4 - PostgreSQL16 High Availability Lab Setup - Setting Up RepMGR16 online without registration, duration 26 minute 28 second in high hd quality. This video was added by user ICyb3r 13 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 104 once and liked it 4 people.