Clouddley Documentation
  • 👋Welcome to Clouddley Documentation.
  • ⚡CLOUDDLEY TRIGGR
    • Triggr Apps
      • 🛠️How-to Guides
        • 📗Deploy a Ruby on Rails App on Clouddley Triggr
        • 📔Deploy a Flask Application on Clouddley Triggr
        • 📙Deploy a .NET Core Application on Clouddley Triggr
        • 📔Deploy a FastAPI App on Clouddley Triggr
        • 📕Deploy a NestJs App on Clouddley Triggr
        • 📙Deploy a Go Application on Clouddley Triggr
        • 📗Deploy a Laravel App on Clouddley Triggr
        • 📓Deploy a Next.js App on Clouddley Triggr
        • 📘Deploy an Express.js Application on Clouddley Triggr
      • 🛠️Extras
        • 🔔Notifications
        • ⚙️Environment Variables
        • 🌐Custom Domain
        • How to Rollback an Application
        • ⏯️How to Pause and Resume Applications
        • Scale applications on Clouddley Triggr
        • 📕Deploy an Application with a Dockerfile on Clouddley Triggr
  • Triggr Databases
    • 🛠️How-to Guides
      • Deploy a MongoDB Database on Clouddley Triggr
      • Deploy a MariaDB Database on Clouddley Triggr
      • Deploy a PostgreSQL Database on Clouddley Triggr
      • Deploy a Redis Database on Clouddley Triggr
      • Deploy a MySQL Database on Clouddley Triggr
    • 🛠️Extras
      • Database Networking on Clouddley Triggr
      • 🔁How to Reset Database Password on Clouddley Triggr
Powered by GitBook
On this page
  • Prerequisites
  • Step-by-step deployment
  • Triggr Database Dashboard
  • Conclusion

Was this helpful?

  1. Triggr Databases
  2. How-to Guides

Deploy a PostgreSQL Database on Clouddley Triggr

Learn how to deploy a PostgreSQL database on Triggr.

PreviousDeploy a MariaDB Database on Clouddley TriggrNextDeploy a Redis Database on Clouddley Triggr

Last updated 2 months ago

Was this helpful?

Deploying and managing a database is easy with . 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 account

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

Step-by-step deployment

1

Accessing Triggr Databases

  • Log into your account.

  • Navigate to and Click on Deploy Database

2

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.

  • Download the public key to your local machine.

  • Run the provided command in your local machine allowing Triggr to connect to your virtual machine.

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

Replace ~/path/to/downloaded/Publickey ,username and ipaddress with your actual values.

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

  • Click Next to continue.

3

Database Name

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

  • Click Next to proceed.

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

5

Confirm Deployment

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

  • Click Go to Dashboard to access and manage it.

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.

Access public and private network details, including username, password, host, port, and database type.

Monitor real-time log streams for troubleshooting and download logs for further analysis.

Manage a list of database users and securely reset passwords as 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 to learn how to deploy various databases on Clouddley Triggr.

other guides
🛠️
PostgreSQL
Clouddley Triggr
Clouddley
Clouddley
Triggr Databases
Accessing Triggr Databases
Configuring the virtual machine to host your database
Defining a unique name for the PostgreSQL database
Selecting the PostgreSQL database type and specifying the version for deployment
PostgreSQL database successfully deployed
The dashboard overview with a high-level summary of database performance and status
View the public and private network connections to the PostgreSQL database
Real-time logs for insights into database activity
Manage database users through the dashboard's users section
Image of Triggr Databases dashboard.
Configuring the virtual machine during app deployment on Triggr Databases.
Configuring database name on Triggr Databases.
User selecting the PostgreSQL database type and version.
Image of PostgreSQL database deployed successfully on Triggr Databases.
An image of the overview section of the PostgreSQL database deployed on Triggr Databases.
An image of the connections section of the PostgreSQL database deployed on Triggr Databases.
An image of the logs section of the PostgreSQL database deployed on Triggr Databases.
An image of the users section of the PostgreSQL database deployed on Triggr Databases.
Page cover image