PostgreSQL

Since may 2016 there is the database software PostgreSQL installed on every pool computer. But there is no preset database instance to keep the pool computer as thin as possible and to make the right management easier.

Instead of that every user can set up and use their database instance. For that you should create the instance in an extra directory beneath the /home:

mkdir postgresql/data
/usr/lib/postgresql/9.3/bin/initdb -D postgresql/data/

This instance can then be started including the specification of the directory:

/usr/lib/postgresql/9.3/bin/postgres -D postgresql/data
# The output should then look like that:
LOG:  database system was shut down at 2016-04-21 17:13:51 CEST
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

Inside the running instance there can be new databases created and used:

/usr/lib/postgresql/9.3/bin/createdb test
/usr/lib/postgresql/9.3/bin/psql test

To end the postgres-serverprocess correctly use Strg+C. Please keep in mind that the instance is part of the /home-directory and will be counted to the quota. Due to that the use of PostgreSQL on the pool computers is only meant for the entry to the subject of databases. If you need a bigger instance, e.g. for a thesis or the Bachelorpraktikum please ask your supervisor. They can create a temporary VM on the cluster.

If you don't need the instance anymore you can delete the directory (the postgres-porcess shouldn't be running anymore!):

rm -rf postgresql/data

For an introduction on PostgresSQL, take a look at the official tutorial


In Other Languages
Translations of this page: