How to run query on JetPatch DB

Let's assume you have JetPatch all in one, you can SSH into the server and run the following command:

psql -U jetpatch -h localhost jetpatchdb

Note: Assumes db username = jetpatch and db name = jetpatchdb. 

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

psql -U intigua -h localhost intiguadb

Prior 5.0:

Enter DB password from manager server intigua.properties:

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

After making any DB change, please restart tomcat on manager server (service tomcat restart).

Post 5.0:

Enter DB password from manager server intigua.properties:

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

After making any DB change,  restart main container

restart intigua-main container