Requirements:

You will need a running Postgres server.

A quick web search will show you how to install one. You basically need a dedicated server running where everybody has access to. It’s also possible to host the database in the Cloud or at you web host.

Create new database

When you create a new library the software will automatically create the new database for you.

All you have to provide is the login information (user & password), the database server (server name or IP address) and the database name - how you want to call the new database (Example: das_element). The software will setup all the tables for you. Nothing that you have to do.

Optional: You can use a SSL certificate.


Setup Postgres Server - docker compose

A easy way to create a new database server is to use Docker Compose

Please make sure to install Docker and Docker Compose first.

  1. create a new folder: database_postgres

  2. create a new text file inside the folder called: docker-compose.yml

  3. add this code snipped into the file …

version: '3'

services:
  postgres:
    image: postgres:13.1
    healthcheck:
      test: [ "CMD", "pg_isready", "-q", "-d", "postgres", "-U", "root" ]
      timeout: 45s
      interval: 10s
      retries: 10
    restart: always
    environment:
      - POSTGRES_USER=root
      - POSTGRES_PASSWORD=password
      - APP_DB_USER=docker
      - APP_DB_PASS=docker
      - APP_DB_NAME=docker
    volumes:
      - ./postgres-data:/var/lib/postgresql/data
    ports:
      - 5432:5432
CODE

4. run this command to start the database:

docker-compose up -d
CODE