All PaaS products should only be used for testing and developing purposes.
Destroy the clusters when you no longer need them, do not saturate the service.
Activate your VPN and connect to the webUI.
Go to PaaS > Products and launch a PostgreSQL cluster, selecting your preferred version.
Select the resources you need and provide a numeric password.
For testing the product use only 1 CPU to save up on resources
When cluster status is ready click on show info and copy the IPs provided.
You need to connect as user postgresql and to the database test
You will then be asked for your numeric password
After initial connection you can create other databases using
create database <databasename>
From your computer:
psql -h 10.112.243.248 -U postgresql test
From hadoop3.cesga.es or dtn.srv.cesga.es:
psql -h 10.117.243.248 -U postgresql test
This product includes 2 of the most popular extensions for managing time series and spatial data
After launching the product, the process of setting up and conecting is the same
In order to use the extensions, load them first in your db
CREATE EXTENSION IF NOT EXISTS postgis CASCADE;
CREATE EXTENSION IF NOT EXISTS timescaledb VERSION '1.7.5' CASCADE;