Deploy a PostgreSQL Database on Clouddley.

Learn how to deploy a PostgreSQL database on Clouddley.

Deploying and managing a PostgreSQL database is easy with Clouddley. PostgreSQL is a powerful open-source relational database known for its robustness and extensibility. This guide walks you through the setup process on Clouddley, ensuring a smooth and efficient deployment experience for developers of all skill levels.

Prerequisites

• A Clouddley account

• A virtual machine on a Cloud platform or a bare metal server.

Step-by-step deployment

1

Accessing Databases

• Log in to your Clouddley account.

• Navigate to Databases and Click on Deploy Database

Accessing Databases

2

Configure your Virtual Machine (VM)

In the Choose or add server dropdown, select your virtual machine (VM) if it’s already listed. If not, select + Add Virtual Machine.

Enter the required details:

VM Host	Provide the host address of your virtual machine.
VM User	Input the username required to access the virtual machine
Port	Specify the port number for the connection

• Use the Clouddley CLI (recommended) or connect via SSH to verify.

Clouddley CLI

The Clouddley CLI is a command-line tool that allows you to interact with the Clouddley Platform from your terminal.

• Open the command line of the remote VM you want to configure to Clouddley and install Clouddley CLI by running the command:

curl -L https://raw.githubusercontent.com/clouddley/cli/main/install.sh | sh

• To add the SSH public key, run the command:

clouddley add key

Using the CLI, you can deploy resources, manage configurations, and automate tasks efficiently.

SSH

• Click Verify to validate the details and confirm the connection.

• Click Next to continue.

Configuring the virtual machine to host your database

3

Database Name

• Provide a unique name for your database to ensure easy identification within the virtual machine (VM).

• Click Next to proceed.

Defining a unique name for the PostgreSQL database

4

Select the Database type and version

• Choose PostgreSQL from the dropdown menu

• Select your preferred version to ensure compatibility with your application.

• (Optional) Enable the Delete Protection option to prevent accidental deletion of your PostgreSQL database.

This feature prevents the database from being destroyed unless explicitly disabled.

• Click on Deploy DB

Selecting the PostgreSQL database type and specifying the version for deployment

5

Confirm Deployment

• After the deployment is complete, your PostgreSQL database is ready.

• Click Go to Dashboard to access and manage it.

PostgreSQL database successfully deployed

Database Dashboard

You can access and manage your database using the user-friendly dashboard interface.

Overview

View details about your database, VM, and settings (e.g., Delete Protection), and use the option to delete the database if it is no longer needed.

The dashboard overview with a high-level summary of database performance and status

Connections

Logs

Users

Conclusion

Deploying a PostgreSQL database on Clouddley is quick, efficient, and scalable. With its database management features, you can focus on your applications while Clouddley handles the heavy lifting. Check out our other guides to learn how to deploy various databases on Clouddley.