...

Requirements

You will need a running Postgres PostgreSQL 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.

...

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

1. Setup ServerInstall Postgres

   1. Linux

   2. MacOS

   3. Windows

   with

   1. Docker Compose

2. Configure Server

3. Create User

...

Install Postgres

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

Depending on you operating system follow the installation instructions (Step 1) below. Make sure to configure the server correctly (Step 2). The last step (Step 3) is to create a User for the actual library.

Install Postgres - 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. See below.

...

Install Postgres

...

- MacOS

It’s recommended to use Homebrew to install Postgres

...

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

...

Install Postgres

...

- Windows

...

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/

...

Install Postgres

...

- 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.

...

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 installation of the Postgres Server you need to configure the server to allow access from a remote workstation. There are two files that need changes:

...

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

Now restart the Postgres service to activate the changes:

# Linux
sudo service postgresql.service restart

# MacOS (if instaleld with homebrew)
sudo brew services restart postgresql

# Windows
1) press Windows key + R to open the 'RUN' dialog
2) type 'services.msc' hit enter
3) find the 'postgresql' service
4) right click -> restart

Edit Firewall

Allow access to the database server, otherwise the connection gets blocked and Users can not connect to the database.

The default Port for Postgres is 5432

# Windows
Control Panel > System and Security > Windows Firewall > Allow an app through Windows Firewall

Create Database User

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

pgAdmin4

...

psql

If you are familiar with the command line you can use psql to create a new user.

The User needs permission to:

• login

• create databases

# postgres is the default postgres database
psql --port 5433 postgres

# create user that is allowed to create new databases and read/write information
CREATE ROLE dbuser LOGIN password 'password';
ALTER USER dbuser CREATEDB;

pgAdmin4

If you prefer a graphical user interface, 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.

...

Edit pg_hba.conf and allow Users access the database.

Can not connect to database

Check if the firewall is blocking the connection. By default Postgres is running on Port 5432