Exploring the database

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


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)


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

Last modified October 5, 2022: Historian article (#107) (5f30dc0)