Versions Compared

Key

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

This article is provided as a technical guide to set up Joget DX 8 with PostgreSQL database on Kubernetes. The following steps were implemented on Ubuntu 22.04, please modify the commands to suit your environment.


Table of Contents

Create Joget Image with PostgreSQL JDBC Driver

Code Block
languagebash
linenumberstrue
# create custom Dockerfile
cat <<EOF > joget-dx8-postgresql-tomcat9.Dockerfile
FROM jogetworkflow/joget-dx8-tomcat9:8.1.1

# Copy postgresql jdbc driver (download from https://jdbc.postgresql.org/download/postgresql-42.7.3.jar)
COPY postgresql-42.7.3.jar /deployments/apache-tomcat/lib/postgresql-42.7.3.jar
EOF

# build docker image
docker build -f joget-dx8-postgresql-tomcat9.Dockerfile --rm -t quay.io/replaceWithYourAccount/joget-dx8-postgresql-tomcat9:8.1.1 .

# push docker image
docker push quay.io/replaceWithYourAccount/joget-dx8-postgresql-tomcat9:8.1.1

Deploy PostgreSQL on K8s using Helm

...

Deploy Joget

Follow the instructions in https://dev.joget.org/community/display/dx8/Joget+on+Kubernetes, replacing the jogetworkflow/joget-dx8-tomcat9 image with the custom image quay.io/replaceWithYourAccount/joget-dx8-postgresql-tomcat9 in the YAMLin Joget on Kubernetes.

Configure Joget Datasource for PostgreSQL

...