3.1.1

• Variable _postgresq_config_path now correctly defaults to _postgresql_data_dir on RedHat systems.

3.1.0

fix: Removed Ubuntu 20.04 from CI tests as reached eol

3.0.0

What's Changed

Features/Breaking changes

• Enable SSL by default by @nathaliereslou in #27 with support for generating self signed certificates
• Changed default value of postgresql_config_change_allow_restart from true to false

Fixes

• Fixes typos in task names, de-duplicate task names

Maintenance

• Switch ansible lint action to ansible/ansible-lint@main

Full Changelog: 2.2.0...3.0.0

2.2.0

What's Changed

• Add variables for feature control, connection customization, and Patroni integration by @davidassigbi in #26

Full Changelog: 2.1.0...2.2.0

2.1.0

Features

• Added variable for controlled restarts: Introduced postgresql_config_change_allow_restart, a new variable to control when the PostgreSQL service can be restarted, ensuring better service availability during configuration changes.

Bug fixes

• Service start fix: Resolved an issue where the PostgreSQL service was not guaranteed to be started after configuration updates.
• Venv creation in dry-run: Fixed a problem where virtual environment creation task incorrectly reported changes in dry-run mode when ansible_check_mode was active.
• Updated variable postgres_users_no_log prefix from postgres to the correct postgresql for improved clarity and standardization.
• Task name cleanup: Removed unnecessary reference to Rockylinux in task name for consistency.

Maintenance

• Pinned molecule-action to version 2.7.40 for compatibility with ansible-core 2.16.
• Updated Rockylinux images used in GitHub Actions to more recent supported versions.

Documentation

• Testing environment updates: Documented the changes to the RockyLinux version used in testing workflows for transparency.

---

Full Changelog: 2.0.0...2.1.0

2.0.0

Breaking changes

• Dropped support for Debian 10: Support for Debian 10 has been removed as it reached its end-of-life on 2024-06-30.

New features

• Vacuum script: Added a PostgreSQL vacuum script along with deployment tasks and molecule tests for validation.
• Backup script directory variable: Introduced postgresql_backup_script_dir variable in defaults/main.yml to specify a custom directory for backup scripts.
• Default PostgreSQL version: Updated the default PostgreSQL version to 16, the latest LTS release.

Fixes

• Dependency resolution: Installed gcc on RedHat hosts to resolve issues with psycopg installation.
• Auto-tuning in check mode: Prevented variable extraction in check_mode due to limitations of the URI module.
• User password security: Prevented potential password exposure by renaming the loop label in user configuration tasks to username.

Documentation

• Vacuum Script Deployment: Updated documentation to include details on deploying the PostgreSQL vacuum script.

Maintenance

• GitHub Actions: Upgraded actions/checkout from v3 to v4.
• .gitignore updates: Added .env to .gitignore to exclude Python virtual environment files from version control.

Style and typo fixes

• Task typo correction: Corrected relication to replication in tasks/setup-vars.yml.
• Loop label update: Changed "Ensure mariadb service" to "Ensure PostgreSQL service" in molecule/shared/tasks/verify_default.yml.

Testing enhancements

• Molecule testing: Improved molecule tests with a dedicated scenario for vacuum script testing and a minimal setup for the default scenario.

---

Full Changelog: 1.0.0...2.0.0

1.0.0

Initial official release