PostgreSQL

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 can use the IP beginning with 10.112.XXX.XXX to connect from your computer providing your VPN is active.

You can also conect to 10.117.XXX.XXX (faster connection) but only from a machine at CESGA, like hadoop3.cesga.es

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>

Examples using psql

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;