What is the best way to connect to an external Postgresql database and archive records into the ruby ​​on rails application database?

Question

PostgreSQL

There is a postgresql database where indicators from sensors are recorded. It is necessary to read data every 3 hours (about 200 thousand records) and accumulate them in the application database.
What I plan to do: create two models and use establish_connection to two different databases, create a rake task to copy active record objects received from an external database to the application database.
I suspect that this option is bad.
Tell me how best to implement?

Answer 1

At least how to implement it will be good at least for what is implemented.
By crown, you can dump the base and pour the dump into another base.