PostgreSQL: Ups, DevOps...
summary
Practical checklist for automating PostgreSQL operations: automate OS/package/config management, replication setup, load‑balancer config and scripted failover; keep major upgrades, schema migrations and daily query analysis manual or heavily tested. Recommend lightweight orchestration like Ansible for fast rollout and testing, and heavier systems (Chef/Puppet/Salt) when you need central control and agents. Warn of real failures — wrong hosts, bad regex templates, dropped WALs, blocking ALTERs — so require test env, runbooks and an on‑call team.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 4:04DB admin tasks
- 11:09When automation needed
- 15:04Automation problems and fixes
- 20:00Automation tools
- 26:09Tool selection and setup
- 31:10Real-world mistakes and lessons
- 34:04Security and procedures
related talks
53mBest practices of using a managed PostgreSQL in the cloud
36mUnlocking the Benefits of Database DevOps and Automation
55mManaging PostgreSQL With Ansible
30mManaging Postgres at scale: Challenges, Tools & Techniques
52mManaging PostgreSQL changes for the Agile DBA
55mManaging PostgreSQL with Puppet
49mBeyond PostgreSQL 17
30mRunning PostgreSQL on Kubernetes in Production: Day 2 Operations with CloudNativePG