Ansible collection optimisation and new manage_dbserver
In this release, we have optimized the roles and added a new role, manage_dbserver. The following are more details:
- Moved dict servers processing inside the role.
- Support for RHEL8/CentOS8 has been added.
- If you are using RHEL8 on Azure, then make sure you have a proper RHEL subscription. - Support for PostgreSQL 13.
- New role manage_dbserver has been added, which allows users to use a playbook for managing the following:
- creating/dropping users.
- managing privileges and roles
- manage physical/logical slots
- managing Postgres parameters
- managing the HBA entries
- creating/dropping extensions in the databases
- managing pgpass file
- copying specific files from local machine to dbserver
- executing SQL scripts/Queries.
- generating a random password for Postgres users.
- Single install support.