System 5 help

Use a PostgreSQL database

Make an empty PostgreSQL database and login, set G5_DB_URL for the Windows user of the host, and open Golden Inventory 5 tools > Start host - PostgreSQL. The host makes the tables at its first start; users connect as with any host.

Steps

  1. On the PostgreSQL server (tested with version 18), make a login and an empty database:
    CREATE ROLE golden5 LOGIN PASSWORD 'a long password';
    CREATE DATABASE golden5 OWNER golden5;
  2. On the host computer, set the database address for your Windows user only, so the password is not on the command line:
    setx G5_DB_URL "postgres://golden5:a long password@db-server:5432/golden5"
    Write a special character of the password in URL form (for example @ is %40). Open a new window after setx.
  3. Open Golden Inventory 5 tools > Start host - PostgreSQL. The host program is goinsy5-server-pg.exe; it makes the tables at its first start.
  4. Users connect as with the local network host or remotely. The desktop window uses only its own file, not the database.

Backups and restore

The certificate files of this host are goinsy5-server.cert.pem and goinsy5-server.key.pem in the data folder.

Related help

Use System 5 on several computers · Back up and restore your data · Connect a second shop or a home computer · All System 5 help