Part8 - PostgreSQL16 High Availability Lab Setup - Testing PostgreSQL HAproxy Keepalived
Hi Everyone,
In this video, we dive deep into testing the high availability (HA) for PostgreSQL 16 using HAProxy and Keepalived. Learn how to perform a test of PostgreSQL high availability in a real-world lab environment to ensure fault tolerance and automatic failover. We’ll cover the key steps in integrating HAProxy for load balancing and Keepalived for VIP management.
📌 Key Topics Covered:
Test HAProxy for PostgreSQL load balancing
Test Keepalived for failover and virtual IP (VIP) management
Testing PostgreSQL with RepMGR replication
Simulating node failure and recovery scenarios
Whether you’re setting up PostgreSQL for production or just curious about HA in PostgreSQL, this tutorial has you covered!
🚀 Previous videos in this series:
Part 7: • Part7 - PostgreSQL16 High Availabilit...
Part 6: • Part6 - PostgreSQL16 High Availabilit...
👍 Don’t forget to like, share, and subscribe for more PostgreSQL tutorials!
Download PGADMIN: https://www.pgadmin.org/download/pgad...
Full Documentation: https://github.com/icyb3r-code/DBAdmi...
Chapters:
00:00 Intro
00:32 Test Scenarios
01:35 Start up Windows VM
02:22 Connect to PG Nodes Using SSH
02:50 Install PGADMIN on Windows VM
03:43 Connect to PostgreSQL Using PGADMIN
03:56 PostgreSQL LAB Network Details.
05:07 Create A test User and Database in Postgres DB.
06:54 Connect to Postgres Using PGAdmin as a Test User.
07:54 Test Switchover using RepMGR.
10:55 Test HAProxy and Keepalived Virtual IP (VIP) failover.
#PostgreSQL16 #HighAvailability #HAProxy #Keepalived #PostgreSQLTutorial #Database #Failover #PostgreSQLSetup #LabSetup #PostgreSQLHA
Watch video Part8 - PostgreSQL16 High Availability Lab Setup - Testing PostgreSQL HAproxy Keepalived online without registration, duration hours minute second in high quality. This video was added by user ICyb3r 08 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 200 once and liked it 2 people.