PostgreSQL

1# yaml-language-server: $schema=https://json-schema.axonivy.com/ivy/12.0.11/ivy.json
2# Postgres as System Database
3# [engineDir]/configuration/ivy.yaml
4SystemDb:
5  # Format: jdbc:postgresql://<host>[:<port>]/<database system>
6  Url: jdbc:postgresql://localhost:5432/AxonIvySystemDatabase
7  UserName: root
8  Password: 1234

If database will be created by the Axon Ivy Engine the encoding is set to UTF8.

Tip

If you experience bad query performance in Portal, then try to increase the setting work_mem in the postgresql.conf configuration file of the database.