Skip to main content
A
AA_99932054-Participant
4-Participant
March 8, 2022
Question

migrate data from postgres to influxdb

  • March 8, 2022
  • 1 reply
  • 1484 views

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

1 reply

B
bchaudhary_4480085-Regular Member
5-Regular Member
March 9, 2022

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

M
MM_902332215-Moonstone
15-Moonstone
March 15, 2022

hi @bchaudhary_448008, 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!

Terms & ConditionsAccessibility statement