Executing SQL commands in the United Manufacturing Hub?

How to execute SQL commands on TimescaleDB using the Shell?

Instructions

  1. First you need to be connected via OpenLens to the United Manufacturing Hub

  2. Go to Pods and select the timescaledb pod

Untitled

Untitled

  1. Open the pod shell

Untitled

Untitled

  1. Execute the following commands:

    1. psql

    Untitled

    b. \c factoryinsight

    Untitled

    c. The SQL commands, e. g. the following commands fix a bug in in older version that processValues do not show up in Grafana (it may take some time until you can enter the next command):

    Untitled

    d. exit

    Untitled

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