Installing a PostgreSQL database to support IBM BAM KieServer is a very simple operation.
In this post we will see how to install PostgreSQL, create a db instance and related schema for persistence of processes and then how to configure a datasource to support KieServer.
We will be using a RedHat 9.x linux environment.
Once IBM BAM OE is installed (see "One shot installation of IBM Business Automation Manager Open Editions on your laptop" link https://community.ibm.com/community/user/automation/blogs/marco-antonioni/2022/10/18/one-shot-installation-of-ibm-business-automation-m) let's install the PostgreSQL package.
All the operations necessary to carry out a basic installation are detailed at https://github.com/marcoantonioni/BAMOE-KieServer-PostgreSQL
To start, let's create a database instance complete with schema and tables for KieServer, 'Install PostgreSQL in RH9' (https://github.com/marcoantonioni/BAMOE-KieServer-PostgreSQL#install-postgresql-in-rh9).
Finally we set the necessary configurations for jdbc driver, datasource and connection pool in the section 'Configure PostgreSQL and JBoss EAP datasource for IBM BAM OE KieServer' (https://github.com/marcoantonioni/BAMOE-KieServer-PostgreSQL#configure-postgresql-and-jboss-eap-datasource-for-ibm-bam-oe-kieserver)