PostgreSQL

Warnings

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.

How to launch

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

Connect to the cluster

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 

    Using the postgresql spatiotemporal product

    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;