Other databases

The following examples demonstrate how to configure a connection to PostgreSQL. Username and password fields are omitted for brevity. These fields are part of the platform installation guides.

relution:
  database:
    type: postgresql
    url: 'jdbc:postgresql://<server-domain>:5432;databaseName=bluerange'

Dedicated Liquibase DB user

By default the relution.database.* connection & credentials are used to perform all Liquibase changes, but a dedicated DB user can be configured to perform them.

First you create a new user in the database and assign him the corresponding DB permissions to perform DDL operations. Then you extend the Relution yaml configuration with the credentials like seen below:

spring:
  #datasource: # this is defined in relution.database.*
  liquibase:
    #default-schema: # this is defined in relution.database.*
    user: <liquibaseUser>
    password: <liquibaseUserPassword>