Create a PostgreSQL instance from Neevcloud Marketplace

Launch a PostgreSQL instance

Navigate to the Neevcloud dashboard, select Server, and click on Create Cloud Server.

Select Image

Select the Marketplace

Select PostgreSQL and Choose the version.

Hardware Configuration

Users can choose different CPU and RAM configurations to personalize their system. General Purpose and Memory Optimized, CPU Optimized, GPU Enabled, and Smart Servers are the options that are offered. Click these links for further information

Select the volumes

Choose the volume size which will be your root disk,

Network configuration

• Public Network:- A public network is a type of network that is open and accessible to anyone, allowing users to connect freely. If you select a public network, you must configure it to allow public access to your server.

• Private Network:- A private network is accessible only to specific individuals or organizations, ensuring that the general public cannot connect to it. If you choose a private network, you must first create a Private network.

Authentication

• SSH_KEY:- An SSH KEY is a source access credential used in the Secure Shell(SSH) protocol, consisting of a pair of public and private keys that authenticate users and establish encrypted communication between a client and a server. it would be best if you had to create an SSH key to access your server.

Access to your server requires an SSH_KEY. It is mandator

• Password:- A password is a secret string of characters used to verify a user's identity and grant access to a system or resource.

To create a secure password with 10 characters, including symbols, Use a mix of uppercase and lowercase letters, Include numbers, and add special characters like !, $, #, etc. Avoid using easily guessable info like names or birthdates.

Generating SSH KEY

If you already have an SSH key, select it. If you don't have one, please follow this link to generate an SSH key.

Add Security Group

Click on Add Security Group. Ensure the required ports for PostgreSQL are allowed

Enter the server name > Click 'Create Server'

Once your instance is created the status will change to Active, and other details will be shown.

SSH

Now How to access the PostgreSQL server follow these steps

First, access the server via SSH using your SSH key. also if you want to access it by using Putty follow these links. Open the command prompt and navigate to the directory where you downloaded the SSH files.

NOTE: if your SSH is not functioning, so you have to set the permission.

cd .\Downloads\

ssh -i  your_ssh_key  ubuntu@your_server_IP_add

It's recommended to create a new database with fresh access details to maintain high security. we are using unique credentials for each new database. While there is a default database and user with access details available in the file /root/pgsql_setup_info.txt,