Autobase for PostgreSQL® automates the deployment and management of highly available PostgreSQL clusters in production environments. This solution is tailored for use on dedicated physical servers, virtual machines, and within both on-premises and cloud-based infrastructures.

For a detailed description of the cluster components, visit the Architecture page.

1. Install Ansible on one control node (which could easily be a laptop)

sudo apt update && sudo apt install -y python3-pip sshpass git
pip3 install ansible

2. Install the Autobase Collection

# from Ansible Galaxy
ansible-galaxy collection install vitabaks.autobase

Or reference it in a requirements.yml:

# from Ansible Galaxy
collections:
  - name: vitabaks.autobase
    version: 2.2.0

1. Prepare inventory

See example of inventory file.

Specify (non-public) IP addresses and connection settings (ansible_user, ansible_ssh_pass or ansible_ssh_private_key_file for your environment

4. Prepare variables

See the main.yml, system.yml and (Debian.yml or RedHat.yml) variable files for more details.

5. Test host connectivity

ansible all -m ping

6. Create playbook to execute the playbooks within the collection:

- name: Playbook
  hosts: <node group name>

  tasks:
    # Start with the 'deploy' playbook, change to 'config' afterwards
    - name: Run playbook
      ansible.builtin.include_playbook: vitabaks.autobase.deploy_pgcluster

If you need to start from the very beginning, you can use the remove_cluster playbook.

Available variables:

• remove_postgres: stop the PostgreSQL service and remove data.
• remove_etcd: stop the ETCD service and remove data.
• remove_consul: stop the Consul service and remove data.

⚠️ Caution: be careful when running this command in a production environment.

We provide personalized support and expert assistance, so you can focus on building your project with confidence, knowing that a reliable partner is always available when you need help.

Choose the support plan that fits your needs: https://autobase.tech/docs/support