cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

migrate data from postgres to influxdb

AA_9993205
4-Participant

migrate data from postgres to influxdb

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

2 REPLIES 2

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

MM_9023322
14-Alexandrite
(To:bchaudhary)

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!

Top Tags