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
Смотрите видео Part8 - PostgreSQL16 High Availability Lab Setup - Testing PostgreSQL HAproxy Keepalived онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ICyb3r 08 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 200 раз и оно понравилось 2 людям.