Build Your Own Cloud Database in Minutes

This is a step-by-step guide for making a private cloud database for your projects for start you just need a cloud server usecase: perfect for personal project, centralized database full control A. Install PostgreSQL on VM Im using OVH Cloud as a VM with ubuntu. # Update the package list to get info on the newest versions of packages $ sudo apt update # Install PostgreSQL database server and additional utilities/extensions $ sudo apt install -y postgresql postgresql-contrib # Start the PostgreSQL service immediately $ sudo systemctl start postgresql # Enable PostgreSQL to start automatically on every system boot $ sudo systemctl enable postgresql B. Create a database and user 1- Start PostgreSQL 17 # Start the PostgreSQL cluster (version 17, cluster name "main") $ sudo pg_ctlcluster 17 main start # List all PostgreSQL clusters with their version, name, port, status, and data directory $ sudo pg_lsclusters Ref Screenshot 2- Create DB and user # Creating database and setting user $ sudo