> For the complete documentation index, see [llms.txt](https://docs.clouddley.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.clouddley.com/databases/how-to-guides/deploy-a-postgresql-database-on-clouddley..md).

# Deploy a PostgreSQL Database on Clouddley.

Deploying and managing a [PostgreSQL](https://www.postgresql.org/) database is easy with [Clouddley](https://clouddley.com/triggr). 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](https://clouddley.com/) account
* A virtual machine on a Cloud platform or a bare metal server.

## Step-by-step deployment

{% stepper %}
{% step %}

### Accessing Databases

* Log in to your [Clouddley](https://clouddley.com/) account.
* Navigate to [**Databases**](https://app.clouddley.com/services) and Click on **Deploy Database**

<figure><img src="/files/ruvrS2Z6oFAWXeTcQdEW" alt="Image of Databases dashboard on Clouddley."><figcaption><p>Accessing Databases</p></figcaption></figure>
{% endstep %}

{% step %}

### 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:

<table><thead><tr><th width="127"></th><th></th></tr></thead><tbody><tr><td><strong>VM Host</strong></td><td><em>Provide the host address of your virtual machine.</em></td></tr><tr><td><strong>VM User</strong></td><td><em>Input the username required to access the virtual machine</em></td></tr><tr><td><strong>Port</strong></td><td><em>Specify the port number for the connection</em></td></tr></tbody></table>

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

{% tabs %}
{% tab title="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:&#x20;

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

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

```bash
clouddley add key
```

Using the CLI, you can deploy resources, manage configurations, and automate tasks efficiently.
{% endtab %}

{% tab title="SSH" %}

* Download the public key to your local machine.
* Ru**n** the provided command on your local machine, allowing Clouddley to connect to your virtual machine.

```
ssh-copy-id -f -i ~/path/to/downloaded/Publickey username@ipaddress
```

{% hint style="info" %}
Replace `~/path/to/downloaded/Publickey` ,`username` and `ipaddress`  with your actual values.
{% endhint %}
{% endtab %}
{% endtabs %}

* Click **Verify** to validate the details and confirm the connection.
* Click **Next** to continue.

<figure><img src="/files/EXJ5A5sOylj5OrGiPmWe" alt="Configuring the virtual machine during database deployment on Clouddley."><figcaption><p>Configuring the virtual machine to host your database</p></figcaption></figure>
{% endstep %}

{% step %}

### Database Name

* Provide a unique **name** for your database to ensure easy identification within the virtual machine (VM).
* Click **Next** to proceed.

<figure><img src="/files/8GoDrX6WPqoSkOsNcH6J" alt="Configuring database name on Clouddley."><figcaption><p>Defining a unique name for the PostgreSQL database</p></figcaption></figure>
{% endstep %}

{% step %}

### 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.

{% hint style="info" %}
This feature prevents the database from being destroyed unless explicitly disabled.
{% endhint %}

* Click on **Deploy DB**

<figure><img src="/files/FRhwBpELYHPwOoIKHfQI" alt="User selecting the PostgreSQL database type and version."><figcaption><p>Selecting the PostgreSQL database type and specifying the version for deployment</p></figcaption></figure>
{% endstep %}

{% step %}

### Confirm Deployment

* After the deployment is complete, your PostgreSQL database is ready.
* Click **Go to Dashboard** to access and manage it.

<figure><img src="/files/OHOsvGtjx072XMotnqhE" alt="Image of PostgreSQL database deployed successfully on Clouddley."><figcaption><p>PostgreSQL database successfully deployed</p></figcaption></figure>
{% endstep %}
{% endstepper %}

## Database Dashboard

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

{% tabs %}
{% tab title="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.&#x20;

<figure><img src="/files/TE04XMTwk2EFvmoDYEC0" alt="An image of the overview section of the PostgreSQL database deployed on Clouddley."><figcaption><p>The dashboard overview with a high-level summary of database performance and status</p></figcaption></figure>
{% endtab %}

{% tab title="Connections" %}
Access public and private network details, including username, password, host, port, and database type.

<figure><img src="/files/64sdHtbBu4LcLENdzPH6" alt="An image of the connections section of the PostgreSQL database deployed on Clouddley."><figcaption><p>View the public and private network connections to the PostgreSQL database</p></figcaption></figure>
{% endtab %}

{% tab title="Logs" %}
Monitor real-time log streams for troubleshooting and download logs for further analysis.

<figure><img src="/files/SFWPOJMmynn9qJFdNUR7" alt="An image of the logs section of the PostgreSQL database deployed on Clouddley."><figcaption><p>Real-time logs for insights into database activity</p></figcaption></figure>
{% endtab %}

{% tab title="Users" %}
Manage a list of database users and securely reset passwords as needed.

<figure><img src="/files/u8jxW2xkSblk9XprqFFi" alt="An image of the users section of the PostgreSQL database deployed on Clouddley."><figcaption><p>Manage database users through the dashboard's users section</p></figcaption></figure>
{% endtab %}
{% endtabs %}

## 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](/databases/how-to-guides.md) to learn how to deploy various databases on Clouddley.