#postgres

I have created a system to manage various aspects of a university subject. Everything works correctly in the Studio, but after installing it on a Windows Server 2022 with Bonita Tomcat Bundle (2022.2) and PostgreSQL 12 on the same machine I have constant server crashes, with exorbitant CPU and RAM consumption when accessing some pages.

I have followed all the recommendations in the documentation to configure PostgreSQL but without success. The server has 16GB of RAM and 4 cores, well above the hardware requirements recommended in the documentation.

Hi,

We are running into case-sensitivity issues due to the discrepancies between the H2 database used by the Studio and our postgres database in QA and production environment. These issues are not detected in the Studio by our developers because the H2 datasources configuration contains a IGNORECASE=TRUE;

From what I understand, H2 is configured to be case insensitive because we want the search in the Portal to be case insensitive. So all type of RDBMS (PostgreSQL, SQL Server, Oracle) must be configured (or at least bonita schema) to be case insensitive.

Hi! Please help!

Community Studio 7.10.3

Community Bundle Tomcat Platform 7.10.4

Postgre 9.3

After importing the Studio BDM from Studio, the tables are created in Postgres. When restarting the platform, errors occur and the platform does not start.

Before import the BDM the platform is working, created users, etc... but restart the bundle:

...