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 UMHLens to the United Manufacturing Hub

  2. Go to Pods and select the timescaledb pod

    Untitled

    Untitled

  3. Open the pod shell

    Untitled

    Untitled

  4. 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 February 17, 2023: update (#208) (ea731fc)