Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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

Code Block

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

Code Block

currentProfile=postgresql