Hey yall,
Most of this is defaulted, but I wanted to share my progress setting up the Ignition tag historian and converting it’s sqlth_table to a TimescaleDB hypertable. This thread was the kickstart I needed, so thank yall!
Step 1:
Connect Ignition to your Timescale DB database using the Postgres Driver
Step 2:
Modify the Datasource History Provider that your Timescale connection auto generated. Basically, disable all partition jobs, pruning, etc.
Step 3:
Make sure tags are configured to historize with your Timescale History Provider.
Step 4:
In pgAdmin, find the autogenerated ‘sqlth_1_data’ table, right-click > Query Tool.
Step 5:
Use - SELECT create_hypertable('sqlth_1_data','t_stamp',migrate_data => 'true', chunk_time_interval => 86400000)
Data Output should display a result confirming creation of tag.
An easy way to confirm the table has been converted is to run the SELECT statement again. If the table was created the first time, your result for the 2nd try will error and say table is already a hypertable.
After these steps, my tags continued to populate the database, the native Perspective Tag Browers and History setup on the different charts worked as expected.
I’ve attached some photos to share more detail. Now to dig further into the list of items @alexraymond shared for compression and more!
