Enterprise HA PostgreSQL on Proxmox: Automated with GitOps & IaC (Terraform & Ansible)

Description

Welcome to a full demonstration of my completely automated, Zero-Touch Provisioning pipeline to deploy an Enterprise-Grade High Availability PostgreSQL Cluster on Proxmox VE. In this video, I walk you through the entire lifecycle of the infrastructure on Proxmox using GitOps and Infrastructure as Code (IaC) with Packer, Terraform, Ansible, and GitHub Actions. 🔥 What you will see in this video: 1️⃣ Golden Image Creation: Starting from scratch, building a base Ubuntu VM Template on Proxmox using Packer and my GitOps IaC repository. 2️⃣ Automated HA Deployment: Spinning up 6 Virtual Machines from the template to automatically deploy an HA PostgreSQL architecture (Leader/Replica with Patroni & PgBouncer, etcd, HAProxy & Keepalived). 3️⃣ Day-2 Operations via IaC: Demonstrating zero-touch GitOps actions directly from GitHub to manage the cluster. This includes graceful DB Switchover/Failover, triggering manual WAL-G base backups to S3 (RustFS), and executing a full Disaster Recovery Point-In-Time Recovery (PITR). 🔗 Repository Links: 💡 Proxmox GitOps IaC (Golden Image Builder): https://github.com/omidiyanto/proxmox-gitops-infrastructure-as-code.git 💡 Main Project (HA PostgreSQL): https://github.com/omidiyanto/proxmox-ha-postgresql.git If you find this project helpful or have ideas for improvements, feel free to check out the repo, drop a star ⭐, or submit a Pull Request! Let me know in the comments if you have any questions about the architecture or the pipeline. #Proxmox #PostgreSQL #GitOps #infrastructureascode #iac #Terraform #Ansible #DevOps #HighAvailability #Patroni #Packer