Use Ansible to herd your Elephants!
summary
Ansible uses SSH and Python plus psycopg2 on targets to install and configure PostgreSQL clusters, with inventories, playbooks and Jinja templates to initdb, write postgresql.conf and produce a pg_hba generator that in the demo outputs four lines but scales to thousands reliably; modules (apt, postgresql_), fact gathering (cache to speed repeated runs) and idempotent tasks make repeatable deployments practical, secrets live in Ansible Vault*, failures stop per-host (global rollback is manual).
AI-written summary · about
chapters (11)
- 0:00Introduction to ansible
- 1:26Core concepts and setup
- 4:58Ad hoc tasks vs playbooks
- 7:28Fact gathering and execution
- 12:46Advanced playbook design
- 20:05Templating with Jinja2
- 24:12DBA-specific automation
- 27:57Practical role management
- 31:41Securing with ansible Vault
- 33:31Best practices and tips
- 38:41Q&A session
