Release 3.1.0

Major release.

Improvements:

• Adding efm_db_function in setup_efm to fix the pg_wal symlink issue
• EFM integration with PgPool2. Variable efm_pgpool2_integration must be set to true
• Adding default value for wal_keep_segments/wal_keep_size in init_dbserver
• Adding ability to create database user with the deployment and PgPoolII PCP user with configuration. manage_pgpool2 now has ability to manage PCP user

Bug fixes:

• Adapted db template reference to allow for value substitution
• Enable PostgreSQL/EPAS service in init_dbserver

Release 3.0.4

Maintenance release including the following fixes:

• Use private_ip in PgPoolII backend configuration
• Avoid concurrency issue when updating primary HBA
• Adding the ability to add efm_parameters with intial configuration of EFM

Release 3.0.3

Maintenance release including the following fixes:

• Autotuning: configure vm.overcommit_ratio

Release 3.0.2

Maintenance release including the following fixes:

• Exec. lookup 'supported_roles' with wantlist=True
• Reduce shared_buffers autotuning
• Use inventory_hostname as inventory key
• Pass input_password to generate_password
• Fix wrong when condition in the upstream_node task
• Pgpool2: run PG dedicated user creation only once

Release 3.0.0

This release comes with new features, improvement, changes and fixes.

Features and improvement

• Making ansible to use inventory: the hosts.yml file is now replaced by a real Ansible inventory file
• Backup capabilities with Barman
• New role for System and Postgres performance auto-tuning.
• Run ansible-lint on push and new PR using Github actions.
• Performance Improvement: execution times are divided by 2. The chart below shows the execution time comparison between the version 2.0.3 and 3.0.0:

Changes

• Split the setup_pem role into 2 new roles: setup_pemserver and setup_pemagent
• The installation of this Ansible collection, when the code is coming from github, must be done with the make install command.

Fixes

• Open services ports with the firewalld module when firewalld is present and active.
• Open Postgres, PEM server, and EFM ports through their setup roles.
• Fix wrong string substitution for RHEL OS.

Release 2.0.2

• Added the capabilities for pgbouncer
• changed end tasks to fail a module
• Added support for user-defined cluster name in EFM
• Fixed python issue for python where keys can be interchanged.

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:

1. Moved dict servers processing inside the role.
2. Support for RHEL8/CentOS8 has been added.
   - If you are using RHEL8 on Azure, then make sure you have a proper RHEL subscription.
3. Support for PostgreSQL 13.
4. 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.
5. Single install support.