How to Automate the PostgreSQL database setup using Ansible role

Here in this video we will how we can setup Postgres SQL database using the Ansible role. We will some of the features of the roles like vars, files and tasks to provision the database and also we will see how we can use the Postgre SQL database module to create database and query the database using SQL queries and execute SQL scripts using the Ansible playbook.