Exploring the database

How to access the TimescaleDB database when using the United Manufacturing Hub

Instructions

Go to Grafana and add a new Postgres datasource.

Host: united-manufacturing-hub.united-manufacturing-hub.svc.cluster.local:5432

database: factoryinsight

user: factoryinsight

password: changeme (if using the default password, otherwise see below)

SSL: required

TimescaleDB: yes

(see also picture further down)

Untitled

How to get the access credentials for TimescaleDB?

The Grafana and factoryinsight password can be found under the Secret “timescale-post-init-pw” (see video). The postgres admin password for the user postgres can be found in the Secret “united-manufacturing-hub-credentials” under PATRONI_admin_PASSWORD