Deploy postgresql oca on cloudzy

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:

1. Active Cloudzy Account: Ensure that you have an
   active Cloudzy account.

2. Available Service Credit: Verify that you have
   enough credit in your Cloudzy account to deploy a new VPS.

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

Step 1:
Select PostgreSQL from the Applications Menu

1. Log in to your Cloudzy Account: Start logging
   into your account through the Cloudzy Control Panel.

2. Navigate to Applications: Go to the
   “Applications” section in the left-hand menu.

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

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

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

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

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

4. 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/[].
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.

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

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

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

1. 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.”

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

3. 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/.

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

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