We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

How to change password for Application User in DQ+
How to set up a Nested Analysis Output Node in DQ+
Using the SQL Node in DQ+
Column Misalignment with Filter Change in Dashboard - DQ+
Using Column Functions & Javascript to create customized data error messages in Analyses in DQ+
Using the API Console in DQ+
Connecting to HIVE as a data source in DQ+ 4.3 or later versions.
Using the Uniqueness Check Node to check for duplicate values in DQ+
Grabbing logs from a failed execution in DQ+
Importing an excel sheet Error (DQ+)

Connecting to Postgres in DQ+

Jarrar Zaidi

April 20, 2020 16:42
Updated

ApplicationDb (Postgres) installed under docker container. To find the location of ApplicationDB in an environment either check from install.properties file located under "/opt/infogix/sagacity-3.x/properties/" OR run docker ps as sagacity user.

Connecting to Postgres DB :

docker exec -it sagacityApplicationDb bash

```
psql -U postgres -d igxsagacity
```
Execute the provided sql scripts.
To exit from Postgres run "\q" and exit from Postgres container type "exit".

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Connecting to Postgres DB :

Related articles