Overview

This guide explains how to connect to and query the JetPatch database on an all-in-one deployment.

The process involves SSH access to the server and using PostgreSQL command-line tools with the appropriate database credentials.

Database Connection

SSH into your JetPatch all-in-one server and run the following command:

psql -U jetpatch -h localhost jetpatchdb

Note: This assumes db username = jetpatch and db name = jetpatchdb.

Note: Some deployments may have intigua (user=intigua, dbname=intiguadb)

For intigua deployments, use:

psql -U intigua -h localhost intiguadb

Enter the DB password from the manager server intigua.properties file located at:

/usr/share/tomcat/default/conf/intigua.properties

After making any DB change, please restart Tomcat on the manager server:

systemctl restart tomcat

/usr/share/intigua/services/data/intigua-main/conf/intigua.properties

After making any DB change, restart the main container:

docker restart intigua-main