Introduction

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.

Supported setups of Postgres Cluster

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

Getting Started

You have the option to deploy Postgres clusters using the Console (UI), command line, or GitOps.

tip

📩 Contact us at [email protected], and our team will help you implement Autobase into your infrastructure.

Console (UI)

The Console (UI) is the recommended method for most users. It is designed to be user-friendly, minimizing the risk of errors and making it easier than ever to set up your PostgreSQL clusters. This method is suitable for both beginners and those who prefer a visual interface for managing their PostgreSQL clusters.

1. Run the Console container

To run the autobase console, execute the following command:

docker run -d --name autobase-console \
  --publish 80:80 \
  --publish 8080:8080 \
  --env PG_CONSOLE_API_URL=http://localhost:8080/api/v1 \
  --env PG_CONSOLE_AUTHORIZATION_TOKEN=secret_token \
  --volume console_postgres:/var/lib/postgresql \
  --volume /var/run/docker.sock:/var/run/docker.sock \
  --volume /tmp/ansible:/tmp/ansible \
  --restart=unless-stopped \
  autobase/console:2.2.0

info

If you are running the console on a dedicated server (rather than on your laptop), replace localhost with the server’s IP address in the PG_CONSOLE_API_URL variable.

tip

It is recommended to run the console in the same network as your database servers to enable monitoring of the cluster status.

2. Open the Console UI

Go to http://localhost:80 (or the address of your server) and use secret_token for authorization.

Refer to the Deployment section to learn more about the different deployment methods.

3. Purchase a Support Package

Deploying and managing PostgreSQL clusters can be challenging, especially without a dedicated database administrator (DBA). With Autobase, it becomes simpler: alongside powerful automation tools, you get DBA as a Service (DBAaaS). This means access to PostgreSQL experts who will assist with deployment, maintenance, and optimization, ensuring your clusters run smoothly.

Explore our support packages to find a plan that fits your needs.

Command line

The command line mode is suitable for advanced users who require greater flexibility and control over the deployment and management of their PostgreSQL clusters. While the Console (UI) is designed for ease of use and is suitable for most users, the command line provides powerful options for those experienced in automation and configuration.

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

   Example:

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

2. Download the autobase repository

   git clone https://github.com/vitabaks/autobase.git

3. Go to the automation directory

   cd autobase/automation

4. Install requirements on the control node

   ansible-galaxy install --force -r requirements.yml 
   note

   If you plan to use Consul (dcs_type: consul), install the consul role requirements

   ansible-galaxy install -r roles/consul/requirements.yml

   Refer to the Deployment section to learn more about the different deployment methods.

5. Purchase a Support Package

   Deploying and managing PostgreSQL clusters can be challenging, especially without a dedicated database administrator (DBA). With Autobase, it becomes simpler: alongside powerful automation tools, you get DBA as a Service (DBAaaS). This means access to PostgreSQL experts who will assist with deployment, maintenance, and optimization, ensuring your clusters run smoothly.

   Explore our support packages to find a plan that fits your needs.