Managing PostgreSQL With Ansible

on YouTube ↗55m

" summary

Shows Ansible actually installing and configuring PostgreSQL end to end: installs PostgreSQL 13 via apt, creates role, database, table, index and runs a query, and uses handlers to reload postgres and template pg_hba.conf. Demonstrates idempotent playbooks (re-runs report no changes), ad‑hoc ansible mode, postgres modules for ping/backup/restore, and default parallelism of 10; examples are from an environment with about 1000 PostgreSQL databases and the demos run and report success.

AI-written summary · about

" chapters (20)

1. 0:00Start
2. 0:33Agenda
3. 1:11Andreas Scherbaum
4. 2:43What Postgres Is
5. 3:36What Is Ensemble
6. 7:47Postgres Modules
7. 12:16Does the Uptime Command Change Anything
8. 13:38Ignore Errors
9. 14:24Running Commands
10. 15:56Playbooks
11. 22:02Gathering Facts
12. 23:22Summary
13. 26:46Install a Postgres Database
14. 27:13How Do I Install Packages
15. 31:34Postgres Ping Module
16. 34:16User Module To Drop Users
17. 43:26Create a Table and an Index
18. 45:01Create an Index
19. 46:14Postgresql Query
20. 49:51Ansible Tower

" related talks

• 48mUse Ansible to herd your Elephants!Julian Markwort · PostgreSQL Conference Europe 2023
• 39mBreakout SessionKenny Gorman · PGConf Silicon Valley 2015
• 55mManaging PostgreSQL with PuppetSteve Singer · PostgresOpen 2013
• 36mPostgreSQL: Ups, DevOps...Aleksey Lesovskiy · HighLoad++ 2014
• 36mPostgreSQL: Ups, DevOps...Aleksey Lesovskiy · HighLoad++ 2014
• 46mUse PostgreSQL to Step Up Your GameEmmanuel Remy · Devoxx France 2023
• 51mWhen Postgres Can't, You Can!Keith Fiske · PostgresOpen 2013
• 57mProper database staging for PostgresNikolay Samokhvalov · HighLoad++ Moscow 2018