PostgreSQL Automation made easy !

PostgreSQL Automation made easy !

The Dalibo Ansible Collections are a series of Ansible components designed to deploy and manage a large number PostgreSQL instances. They contain roles for every major domain of the PostgreSQL lifecycle : backups, monitoring, HA, security, etc.

The collections are open-source and available freely via Ansible Galaxy.

Features

We offers 4 collections for different kind of usage:

All the major Linux distributions are supported: Red Hat, Rocky, debian, Ubuntu.

Installation

$ ansible-galaxy collection install dalibo.essential
$ ansible-galaxy collection install dalibo.advanced
$ ansible-galaxy collection install dalibo.extras
$ ansible-galaxy collection install dalibo.pglift

Demo

Simply add the roles you want in your playbook like this:

---
- name: Install a complete PostgreSQL HA environment
  hosts: ''
  roles:
    - dalibo.essential.repo_pgdg
    - dalibo.essential.postgresql
    - dalibo.essential.pglift
    - dalibo.essential.pg_activity
    - dalibo.advanced.patroni
    - dalibo.advanced.pgaudit
    - dalibo.extras.logrotate
    - dalibo.extras.haproxy
    - dalibo.extras.keepalived

The collection also include a complete deploy playbook that can be called directly

$ ansible-playbook dalibo.essential.deploy --limit database

Licence

The Dalibo Ansible Collections are licensed under PostgreSQL license.

Support

We need your feedback and ideas! Let us know what you think of this tool, how it fits your needs and what features are missing.

You can either open an issue or send a message at contact@dalibo.com.

Contributors

The Dalibo Ansible Collections are maintained by the following Dalibo Labs team members, with of many from the open source community: