Hello all,
I've been asked whether it is possible to save/restore tag history data later on.
For example, I have my Tag Historian POSTGRESQL database partitioning every month, is it possible to save that partition and restore it at a later date should it be required for review (say of commissioning data).
Anyone done this? I haven't looked too hard yet, but it looks like it would be a very manual process!
I was thinking of:
Back up sqlth_data_x_yyyy_d
back up annotations table
back up or note values in sqlth_partitions
back up sql_te
Then
restore data table (in to say a dev system)
restore sqlth_te
restore annotations
add references for the data tables with the start/end datetime sas per the partition table.
Is this feasable?