Schedule - PGConf.EU 2023
Use Ansible to herd your Elephants!
Are you doing a lot of repetitive work? Running deeply-nested for-loops in Bash to execute the same commands via SSH on all your clusters? There is an easier, more robust and extensible solution: Ansible.
Ansible can be used nearly everywhere, as it only requires Ansible (on your machine), Python (on the managed machines), and SSH (connecting the two) to work. This makes it really useful for managing all of your PostgreSQL clusters. Simply define an inventory of hosts, write some playbooks for the tasks you want to execute on all clusters and let Ansible take care of the rest.
The task will illustrate how Ansible can be used to install, configure, and administrate PostgreSQL clusters. We'll see which patterns can be used to write efficient playbooks and which modules can be used to make interactions with PostgreSQL clusters really easy.