Page History

...

1. Create a database in PostgreSQL; name it jwdb (or another preferred name).
2. Download jwdb-postgresql-v4.psql and load this SQL file into the database.
3. In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-postgresql.properties.
4. Edit joget-installation-directory/wflow/app_datasource-postgresql.properties in a text editor, then insert contents as shown in Figure 1 below. You may need to edit the configuration (such as datasource URL, database user/password) according to your environment.
5. Edit joget-installation-directory/wflow/app_datasource.properties in a text editor, and change the contents as shown in Figure 2 below. This is to activate the datasource profile named "postgresql".
6. Download the PostgreSQL JDBC driver from http://jdbc.postgresql.org/download.html, and copy it into joget-installation-directory/apache-tomcat-xxxx/lib
7. Download Shark.conf, and copy it into joget-installation-directory/apache-tomcat-xxxx/webapps/jw/WEB-INF/classes/conf (you will need to create the conf directory first)
8. Restart Joget Workflow server.

Figure 1: Datasource Profile Configurations

workflowUser=postgres
workflowPassword=postgres
workflowDriver=org.postgresql.Driver
workflowUrl=jdbc\:postgresql\://hostname/jwdb

You may need to change the datasource URL, database user and database user's password accordingly.

Figure 2: datasource.properties

currentProfile=postgresql