Creating and managing databases using Ansible

The community collection for PostgreSQL comes with more than 20 modules and a few plugins. It is possible to use these modules and plugins to automate PostgreSQL database operations, including creating, dropping, and updating databases, tables, users, and other resources in the database server.

Ansible community.postgresql prerequisites

If you are accessing PostgreSQL from a remote node (for example, an Ansible control node), then you need to install the psycopg2 Python library on this machine to use these PostgreSQL modules:

$ pip install psycopg2

In the next section, we will execute tasks from the database node itself (node1) using Ansible. This library is not required as the database server has already been configured with the required dependencies.

In the next section, you will learn how to manage database operations using Ansible and the community.postgresql collection.

Managing the database life cycle

In this...