Deploy a PostgreSQL Database on Clouddley Triggr
Learn how to deploy a PostgreSQL database on Triggr.
Deploying and managing a PostgreSQL database is easy with Clouddley 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 Triggr, 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 bare metal server.
Step-by-step deployment
Accessing Triggr Databases
Log into your Clouddley account.
Navigate to Triggr Databases and Click on Deploy Database

Configure the Virtual Machine (VM)
Begin by setting up your virtual machine environment to host your database. Follow the instructions below:
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.
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 install Triggr, run the command:
clouddley triggr install
Using the CLI, you can deploy resources, manage configurations, and automate tasks efficiently.
Click Verify to validate the details and confirm the connection.
Click Next to continue.

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.
Click on Deploy DB

Triggr Database Dashboard
You can access and manage your database using the user-friendly dashboard interface.
View details about your database, VM, and settings (e.g., Delete Protection), and use the option to destroy the database if no longer needed.

Conclusion
Deploying a PostgreSQL database on Clouddley Triggr is quick, efficient, and scalable. With Triggr's database management features, you can focus on your applications while Clouddley Triggr handles the heavy lifting. Check out our other guides to learn how to deploy various databases on Clouddley Triggr.
Last updated
Was this helpful?