Breakout Session
summary
Shows concrete recipes using Ansible to manage PostgreSQL at scale with working code and real deployments at Rackspace and objectrocket, not vague promises. Demonstrates Ansible playbooks, roles and modules, uses dynamic inventory for AWS and Rackspace, runs SQL DDL like create index and user grants across 20+ databases in parallel, automates backups, replication setup and pg_hba.conf templating with GitHub versioned templates, and reports actual run results and failure behavior so the procedures are reproducible and auditable.
AI-written summary · about
chapters (26)
- 0:00Intro
- 1:51Core Modules
- 4:49Ansible and PostgreSQL
- 5:39Do you need ansible
- 7:07Item potency
- 7:49Provisioning
- 9:05Output
- 9:53PostgreSQL Modules
- 11:16Operations
- 11:41Management
- 14:04Things you can do
- 15:34Oneliners
- 16:15Show me everything
- 16:45Create index statement
- 17:37Push script
- 18:31Call mill
- 19:42Triage
- 20:13Postgres
- 20:53Command Line
- 21:20Advanced Command Line
- 21:36PG Shard
- 22:16Performance Tuning
- 22:40Use modules
- 26:04Questions
- 33:03Dynamic Inventory
- 36:29Template
related talks
55mManaging PostgreSQL With Ansible
11mRoad to Percona Live 2022 - Bruce Momjian - PostgreSQL Talk
46mBig databases, many servers, data center or cloud - it's all here!
46mUse PostgreSQL to Step Up Your Game
36mHighly Available PostgreSQL Database Cluster Creation & Monitoring in Minutes
35mAnswering the Big Question About Chef, Postgres and All That
52mManaging PostgreSQL changes for the Agile DBA
04mRoad to Percona Live 2022 - Andreas Scherbaum - PostgreSQL Talk