3 ms·
Moving data is always the trickiest part! We get a lot of Heroku customers who need help with their data migration. My honest answer is there will always be som
by lvangool 3y ago
Moving data is always the trickiest part! We get a lot of Heroku customers who need help with their data migration. My honest answer is there will always be some downtime while the switch over is happening, but we know of a few ways to reduce it. Unfortunately Heroku PG databases don't allow outside replication setup, so we can't really baseline your data and then close the replication gap with a shorter downtime. But we do support multi-DB solutions so we can run against an old and new DB at the same time while data is gradually being moved over. If you're interested, ping me at hello-at-cloud66.com if you want to discuss further :)
- jmuguy 3y agoWe'll keep that in mind, we're currently locked into a (ridiculous) enterprise contract with them. But it expires in November :) We're considering using this https://bucardo.org/Bucardo/ https://bucardo.org/Bucardo/ based on this https://www.porter.run/blog/migrating-postgres-from-heroku-to-rds https://www.porter.run/blog/migrating-postgres-from-heroku-t... Going to give it a shot when I have some free time.
- rudi_mk 3y agoHello! Author of that little blog post there. Happy to be hit up with thoughts/feedback when you give it a shot!