How can I configure BonitaSoft to use PostgreSQL instead of H2

I’m a beginner and I’m struggling to set it up and not sure which files or settings need to be changed. Can I deploy my application without this configuration, or is PostgreSQL mandatory for production?

Hi @houssemeddine.weslat

I’d recommend taking a look at this and follow the steps: Database configuration | Bonita Documentation

The default H2 database should not be use on production, it is for testing purposes only. If you’re using Bonita Community Edition you may use PostgreSQL.

Hope this helps.
Cheers!
-Thalia

The only information provided in this link is to edit postgresql.conf and set a non-zero value for max_prepared_transactions. However, I need guidance on the exact configuration required in Bonita to make this work. Could you please provide a step-by-step guide to configure it properly and explain how I can test it? I would really appreciate your help

Hi @houssemeddine.weslat

I’ve created a :video_camera: short video to better explain how to achieve this configuration: https://youtu.be/C2N092D_K98

To make it easier, I will be using a PostgreSQL Docker image that already contains all the necessary configuration for Bonita (available on Github). I have previously created a Docker image with a Bonita application using Bonita 2023.2. I am using docker compose.

:link: Useful links:
Database configuration documentation: Database configuration | Bonita Documentation
Deploying Bonita with Docker: Deploy Bonita Runtime with Docker | Bonita Documentation

Hope this helps.
Cheers!
-Thalía

1 Like

Thank you so much!
The video and resources were incredibly helpful. I followed the steps, and the issue is now resolved. Your explanation made it so much easier to understand. Cheers! :blush:

1 Like

This topic was automatically closed 2 hours after the last reply. New replies are no longer allowed.