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