Skip to main content
S
sabharees15-Moonstone
15-Moonstone
November 24, 2023
Question

Migrating from InfluxDB to PostgreSQL

  • November 24, 2023
  • 2 replies
  • 4324 views

I have a list of streams (InfluxDB as persistence provider) with data in it, and I would like to migrate to Postgres (the default persistence provider)

Now, how can I proceed further? Does Thingworx provide any migration tools?
If I use the export data option, which is not working,

2 replies

Rocko
Rocko19-Tanzanite
19-Tanzanite
November 24, 2023

If there is an official tool, PTC support will know and be able to provide the link. most probably, this will be a manual effort, but you should create a ticket with support.

V
VladimirRosu_11662719-Tanzanite
19-Tanzanite
November 24, 2023

I suggest as @Rocko below opening a support ticket, because the Export Data option should be the thing to use here.

Out of curiosity, what exactly is not working?

S
sabharees15-MoonstoneAuthor
15-Moonstone
November 24, 2023

If I export the data from streams using the Export Data option, and then change the persistence provider to Thingworx PP from Influx PP, 
I get a successfully imported data message in the application log but am not able to see any data in the stream.

V
VladimirRosu_11662719-Tanzanite
19-Tanzanite
November 27, 2023

I saw the fact you specified "successfully imported" but I did not see that you imported - is that a typo?.

Specifically the steps should be:

1. Export data from Stream using Export Data

2. Change the Stream's PP (Restart the Stream after changing the PP)

3. Import back the data

 

Terms & ConditionsAccessibility statement