Enterprise HA PostgreSQL on Proxmox: Automated with GitOps & IaC (Terraform & Ansible)
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...
💡 Main Project (HA PostgreSQL): https://github.com/omidiyanto/proxmox...
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