The Psono server requires a postgres database with some extensions. This section will explain how to install one and prepare it for the Psono server.

Preamble

This guide is covering the installation on Ubuntu 16.04 LTS and CentOS 7. Ubuntu 12.04+ LTS and Debian based systems should be similar if not even identical to the 16.04 Installation.

Installation with Docker

If you have docker running, then the database is just one command away:

  1. First create the folder for your data e.g.:

    sudo mkdir -p /opt/docker/psono/postgres
    
  2. Second start the database

    docker run --name psono-database \
     -v /opt/docker/psono/postgres:/var/lib/postgresql/data \
     -e POSTGRES_USER=postgres \
     -e POSTGRES_PASSWORD=password \
     -d --restart=unless-stopped \
     -p 5432:5432 postgres:9-alpine
    

Installation with Ubuntu

We will be using postgres (tested with version 9.6, but every 9.x version should work):

  1. First install some requirements

    sudo apt-get install postgresql postgresql-contrib
    
  2. Now lets switch the postgres user

    sudo su - postgres
    
  3. Create our new DB

    createdb psono
    
  4. Now switch the command prompt to postgres command prompt

    psql psono
    
  5. Followed by some nice postgres commands to create the user and grant all privileges:

    CREATE USER psono WITH PASSWORD 'password';
    GRANT ALL PRIVILEGES ON DATABASE "psono" to psono;
    
  6. Install some necessary extensions:

    CREATE EXTENSION IF NOT EXISTS ltree;
    CREATE EXTENSION IF NOT EXISTS "pgcrypto";
    
  7. (optional) If you want to use this database for unit testing, you should also do:

    ALTER USER psono CREATEDB;
    
  8. To exit this shell and return to your normal user do:

    \q
    Ctrl + D
    

    Other databases are not supported because of missing ltree extension

  9. (optional) Adjust pg_hba.conf in /etc/postgresql/9.5/main/

    Depending on your setup you might get FATAL: Ident authentication failed for user which makes it necessary to adjust the pg_hba.conf e.g. add the following lines:

    host    psono             psono             127.0.0.1/32            md5
    host    psono             psono             ::1/128                 md5
    

    Afterwards restart postgres e.g.

    service postgresql restart
    
  10. (optional) Allow network connections

    Depending on your setup you might need postgres to listen on public interfaces, allowing other devices in the network to connect to your host. For that edit postgresql.conf in /etc/postgresql/9.5/main/ and add the following line:

    listen_addresses = '*'
    

    Afterwards restart postgres e.g.

    service postgresql restart
    

Installation with CentOS

We will be using postgres (tested with version 9.6, but every 9.x version should work):

  1. First install some requirements

    sudo yum -y install postgresql-server postgresql-contrib
    sudo postgresql-setup initdb
    sudo systemctl start postgresql
    sudo systemctl enable postgresql
    
  2. Now lets switch the postgres user

    sudo su - postgres
    
  3. Create our new DB

    createdb psono
    
  4. Now switch the command prompt to postgres command prompt

    psql psono
    
  5. Followed by some nice postgres commands to create the user and grant all privileges:

    CREATE USER psono WITH PASSWORD 'password';
    GRANT ALL PRIVILEGES ON DATABASE "psono" to psono;
    
  6. Install some necessary extensions:

    CREATE EXTENSION IF NOT EXISTS ltree;
    CREATE EXTENSION IF NOT EXISTS "pgcrypto";
    
  7. (optional) If you want to use this database for unit testing, you should also do:

    ALTER USER psono CREATEDB;
    
  8. To exit this shell and return to your normal user do:

    \q
    Ctrl + D
    

    Other databases are not supported because of missing ltree extension

  9. (optional) Adjust pg_hba.conf in /var/lib/pgsql/data

    Depending on your setup you might get FATAL: Ident authentication failed for user which makes it necessary to adjust the pg_hba.conf e.g. add the following lines:

    host    psono             psono             127.0.0.1/32            md5
    host    psono             psono             ::1/128                 md5
    

    Afterwards restart postgres e.g.

    systemctl restart postgresql
    
  10. (optional) Allow network connections

    Depending on your setup you might need postgres to listen on public interfaces, allowing other devices in the network to connect to your host. For that edit postgresql.conf in /var/lib/pgsql/data and add the following line:

    listen_addresses = '*'
    

    Afterwards restart postgres e.g.

    systemctl restart postgresql
    
Edit me