topic migrate data from postgres to influxdb in ThingWorx Developers

migrate data from postgres to influxdb

AA_9993205 — Tue, 08 Mar 2022 11:07:31 GMT

Hi,

i want to set influxdb for my streams and value streams however i dont know how to get previous data from postgres. the current method of importing and importing thing is quite tedious as i have 100gb of data and no of facilities. is there any other method.

thanks

Adarsh

Re: migrate data from postgres to influxdb

bchaudhary — Wed, 09 Mar 2022 08:09:36 GMT

Hello @AA_9993205 ,

pls check the given article explaining the method of migration:

https://www.ptc.com/en/support/article/cs323473

https://www.ptc.com/en/support/article/cs323425

Revert back if you have any further queries.

Regards

Bhawna

Re: migrate data from postgres to influxdb

MM_9023322 — Tue, 15 Mar 2022 12:10:45 GMT

hi @bchaudhary, I have a requirement where I am using Influx DB for time-series data and Postgres for non-timeseries data. Initially, I used Postgres DB, but now I want to change it with Influx DB. Influx DB is running on a Linux system and Postgres is installed on Windows. When I am using Influx DB with a Value Stream to store data, it stores the new data. But I also want to migrate the older data from Postgres to Influx DB, so I followed the steps you shared. I am importing data from the same environment. While doing so, I am facing an error in my logs "Import failed com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider. {}"

I am trying to resolve this error, but I am unable to find any solution. Can you please help me out with this?

Thank you!