Quick Start Guide
This guide will help you get started with Thalassa Cloud’s Database as a Service (DBaaS) in minutes. You’ll learn how to create your first PostgreSQL cluster, connect to it, and perform basic database operations.
Prerequisites
Before you begin, ensure you have:
- Thalassa Cloud Account: A valid Thalassa Cloud account with API access
- API Token: Your API authentication token
- VPC and Subnet: A VPC with at least one subnet in your desired region
- Security Group: A security group configured to allow PostgreSQL connections (port 5432)
- PostgreSQL Client: A PostgreSQL client like
psql
for connecting to your database
Step 1: Create Your First Database Cluster
Using the Console
- Navigate to DBaaS: Go to the DBaaS section in your Thalassa Cloud console
- Create Cluster: Click “Create Database Cluster”
- Configure Basic Settings:
- Name:
my-first-db
- Description:
My first PostgreSQL cluster for learning
- Engine: PostgreSQL
- Version: 17.5
- Name:
- Choose Instance Type: Select
DB PGP Medium
(2 vCPUs, 4GB RAM) - Configure Storage: Set storage to 10GB Block
- Set Replicas: Choose 2 replicas for high availability
- Network Configuration:
- Subnet: Select your private subnet
- Security Groups: Add your database security group
- Review and Create: Review your configuration and click “Create Cluster”
Step 2: Creating databases & roles
After creating the database cluster, you can create new roles and databases through the database overview window. A new database within the cluster requires an existing role to be it’s owner.
Step 3: Connect to Your Database
by default, the database cluster is only available within an VPC. If you want to access it from your laptop, either setup a VPN or similar solution within your VPC, or utilize a Loadbalancer to configure access to the database.
Using a load balancer
- In IaaS, create a target group within the same VPC as the database cluster. Once created, add the DBcluster endpoint to it’s attachment list.
- Next, create a load balancer with a listener (suggestion using port
5432
, protocoltcp
). Attach the previously created target group to this listener. - For additional security, configure IP ACLs on the listener.
- Once the load balancer has been fully provisioned, you can connect to the database through the load balancer’s IP.