Available since version 3.3.0-Moonwalker

Introduction

PostgreSQL, or also known as Postgres, is a free and open source relational database management system that emphasizes SQL extensibility and compliance.

https://www.postgresql.org/

Since the release version 3.3.0 of Onesait Platform, PostgreSQL has been certified as ConfigDB, to give Projects and Products based on the Platform even more flexibility and allow them to choose whether to use MariaDB or PostgreSQL as their configuration database.

Configuration

To configure PostgreSQL as ConfigDB, simply change the following Yaml properties of the different Platform modules that require it when deploying.

master: 
   datasource:
      hikari: 
        jdbc-url: jdbc:postgresql://localhost:5432/onesaitplatform_master_config
        username: <postgres_username>
        password: <postgres_password> 
        driver-class-name: org.postgresql.Driver
spring:
   datasource:
     hikari:
      jdbc-url: jdbc:postgresql://localhost:5432/onesaitplatform_config
      username: <postgres_username>
      password: <postgres_password>
      driver-class-name: org.postgresql.Driver
   jpa:
     properties.hibernate.dialect: org.hibernate.dialect.PostgreSQL95Dialect

PostgreSQL certification as ConfigDB

Introduction

Configuration