Requirements

You will need a running Postgres server.

You need a dedicated server running where everybody has access to over the network. It’s also possible to host the database in the Cloud or at you webhost. A quick web search will show you how to install one or see operating system depended installation instructions below.

Creating a new library

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.

Install Postgres Server

Setup Server
Linux
MacOS
Windows
with Docker Compose
Configure Server
Create User

Setup Postgres Server - Linux

Installation guide for Debian:

https://linuxize.com/post/how-to-install-postgresql-on-debian-10/

Make sure to setup the postgresql.conf and pg_hba.conf correctly.

Setup Postgres Server - MacOS

It’s recommended to use Homebrew to install Postgres

https://www.sqlshack.com/setting-up-a-postgresql-database-on-mac/

brew install postgres

Make sure to setup the postgresql.conf and pg_hba.conf correctly.

Setup Postgres Server - Windows

On a machine that’s accessible by everybody on the network (e.g. Virtual Machine) install the Postgres Software.

Download the installer:
https://www.postgresql.org/download/windows/

Installation Guide:
https://www.enterprisedb.com/docs/supported-open-source/postgresql/installer/02_installing_postgresql_with_the_graphical_installation_wizard/01_invoking_the_graphical_installer/

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.

create a new folder: database_postgres
create a new text file inside the folder called: docker-compose.yml
add this code snipped into the file …

version: '3'

services:
  postgres:
    image: postgres:14.4
    restart: always
    ports:
      - 5432:5432
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=password
    volumes:
      - ./postgres-data:/var/lib/postgresql/data

run this command to start the database:

docker-compose up -d

Configure Postgres Server

After the setup of the Postgres Server you need to configure the server to allow access from a remote workstation. There are two files that need changes:

configure database to enable networking
1. edit the file: postgresql.conf
  Linux: /etc/postgresql/{version}/main/postgresql.conf
  MacOS: /usr/local/var/postgresql.conf
  Windows: C:\Program Files\PostgreSQL\{version}\data\postgresql.conf
2. remove the # before the line: listen_addresses = '*'
  This allows access from all IP addresses.
3. save the file
allow access from remote workstation
1. edit the file: pg_hba.conf
  Linux: /etc/postgresql/{version}/main/pg_hba.conf
  MacOS: /usr/local/var/pg_hba.conf
  Windows: C:\Program Files\PostgreSQL\{version}\data\pg_hba.conf
2. add this line to the block IPV4:

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
# IPv4 local connections
host    all             all             0.0.0.0/0               trust

Create Database User

Create a User that can read/write the library information to the database.

pgAdmin4

Use the tool pgAdmin4 to view & edit your Database. You can install the software on any workstation to access the Database server. When you start the application for the first time you have to set an master password - it’s only for your local workstation to access pgAdmin4.