Configuring Patroni can be challenging and time-consuming, but thanks to Autobase, the deployment process becomes much easier. Whether you’re deploying on-premises or in the cloud, such as Google Cloud or Amazon Web Services, Autobase simplifies the process. With Autobase’s console UI, you simply enter your server information and select the version you want, and then Autobase takes care of the rest.
Autobase uses Ansible templates to perform the tasks, and it requires SSH access to the server, either through a password or SSH key. The user account used to access the server must have root or sudo privileges to ensure the necessary tasks can be executed properly.
how to install autobase console ui
Autobase utilizes Ansible templates to carry out the tasks and requires SSH access to the server, either via password or SSH key. The user account used to access the server must have root or sudo privileges to allow the execution of necessary operations.
How to Install Docker on Ubuntu 24.04 LTS: A Step-by-Step Guide
once you install docker you can use the below command to pull autobase image and started it
| 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.1.0 |
Note: If you are running the console on a dedicated server (rather than on your laptop), replace localhostwith the server’s IP address in the PG_CONSOLE_API_URL variable.
Note: It is recommended to run the console in the same network as your database servers to enable monitoring of the cluster status.
- Open the Console UI: go to http://localhost:80 (or the address of your server) and use
secret_tokenfor authorization.
how to use autobase
now you can access the console ui , you can started installing partoni matter of clicks
just you need to click CREATE CLUSTER button
From the available options, you can select the server and its specifications. For instance, in the image below, you’ll see the server specs on the left, and on the right, the estimated cost for the chosen configuration. Additionally, you can specify the region where you want to deploy the server.
For on-premises deployment, you need to specify the hostname and IP address of the server. You can perform the installation on three nodes, but it is not recommended to use only two nodes for optimal performance and high availability.
Next, you need to specify the authentication method by providing the username and selecting whether to authenticate using a password or SSH key.
Another great feature of Autobase is that it can configure the cluster VIP, and you also have the option to have it set up HAProxy as part of the deployment.
You can also specify the environment, whether it’s production or development, provide a cluster name, and choose the desired PostgreSQL version.
I have already deployed the cluster, and as shown on the page, it will create a password and user for the application to use when connecting to Patroni. Additionally, you can view the status of the Patroni cluster.