Show Categories

How to Deploy PostgreSQL with Cloudzy’s One-Click App

Deploying PostgreSQL on your Cloudzy VPS with the One-Click App is a quick and straightforward way to establish a robust database environment. This guide will take you through each step, from selecting your VPS configuration to accessing and confirming your PostgreSQL installation. Whether you’re setting up a new database for development, testing, or production purposes, this comprehensive tutorial will ensure your PostgreSQL server is operational, secure, and ready to meet your needs in no time.

Prerequisites

Before you begin, make sure you have the following:

Active Cloudzy Account: Ensure that you have an active Cloudzy account.
Available Service Credit: Verify that you have enough credit in your Cloudzy account to deploy a new VPS.
Operating System Compatibility: The PostgreSQL One-Click App is compatible with the following Ubuntu versions: Ubuntu Server 20.04, Ubuntu Server 22.04, and Ubuntu Server 24.04.

Log in to your Cloudzy Account: Start logging into your account through the Cloudzy Control Panel.
Navigate to Applications: Go to the “Applications” section in the left-hand menu.
Select PostgreSQL: In the Applications section, under the “All Applications” category, find and select the PostgreSQL application. This will take you to the next step, where you can configure your new VPS with PostgreSQL.

Click Deploy Service: A blue “Deploy Service” button will appear after selecting the PostgreSQL application. Click on this button to start setting up your PostgreSQL VPS.

Step 2: Configure Your VPS

Select Your Server Location: On the configuration page, you’ll be prompted to choose a server location from the available options. For optimal performance, pick a location that aligns with your audience’s geographical area. Options may include regions like Miami, Las Vegas, or Frankfurt.
Choose Your Operating System:

Under the “Image” section, select the operating system on which PostgreSQL will run. The PostgreSQL One-Click App is compatible with Ubuntu Server 20.04, 22.04, and 24.04. Choose the version that best suits your requirements.

Select Your VPS Plan: Choose a VPS plan that matches your needs in terms of CPU, memory, storage, and bandwidth. For a moderate workload, you might opt for a plan with 2 vCPUs, 2 GB of RAM, and 50 GB of storage.

Set Up SSH Key (Optional):

For secure, passwordless access to your VPS, you can add an SSH key by clicking “Add New SSH Key.” If you need help with setting up or using SSH keys, check out [https://cloudzy.com/kb/linux/connection/](this guide on SSH key configuration)[]. If you prefer not to use SSH keys, you can skip this step. Additionally, consider the IPv4 and IPv6 options, which may vary in pricing depending on your selection.

Assign a Hostname: Input a hostname for your VPS. This can be something like “PostgreSQL-US-Miami-2gb” or any other custom name that helps you easily identify your server.

Assign a Hostname: Input a hostname for your VPS. This can be something like “PostgreSQL-US-Miami-2gb” or any other custom name that helps you easily identify your server.

Review and Deploy: Double-check all your configuration settings. Once you’re satisfied, click the “Deploy Now” button to start the deployment of your PostgreSQL VPS. The system will then initiate the setup process, which you can monitor through the progress bar.

Step 3: Access Your PostgreSQL Server

Wait for VPS Creation: After clicking “Deploy Now,” the system will begin creating and configuring your VPS. This process typically takes a few minutes, during which you’ll see a progress indicator showing steps like “Preparing Network,” “Preparing Disk,” “Initializing,” and finally, “Active.”

Retrieve Login Information: Once the VPS creation is complete, you’ll be directed to a confirmation screen that displays your server’s IP address, username, and password. It’s crucial to note these details, as you will need them to access your PostgreSQL server.

Connect via SSH: You can now connect to your VPS via SSH using the provided credentials. If you’re unfamiliar with SSH or need guidance on connecting, refer to [https://cloudzy.com/kb/linux/connection/](This guide).
Select the Default Server for PostgreSQL Installation: Upon connecting to your VPS via SSH, you’ll be prompted to enter the host for the PostgreSQL server. You can press Enter to accept the default server IP provided. This step will trigger PostgreSQL's final setup and configuration on your VPS.

Verify PostgreSQL Installation: After confirming the server host, the installation process will be complete, and your PostgreSQL server will be ready. You can verify the PostgreSQL installation and retrieve the credentials by accessing the /root/.postgres-env file. To view the contents, use the following command:

cat /root/.postgres-env

This file contains important details, such as the PostgreSQL user and password, which you will use to manage your databases. Make sure to securely store this information for future use.

Your PostgreSQL server is now fully set up and ready for you to start managing your databases securely and efficiently.