Hacker News Reader

Comment by jmuguy | Hacker News Reader

Does Cloud 66 have any resources on migrating a large (~300 GB) Postgres DB off Heroku, with minimal downtime? This has been our biggest sticking point when thinking about leaving Heroku.

View on HN

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 :)

We'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/ based on this https://www.porter.run/blog/migrating-postgres-from-heroku-t...

Going to give it a shot when I have some free time.

Hello! Author of that little blog post there. Happy to be hit up with thoughts/feedback when you give it a shot!

Thank you so much for writing that. I was starting to lose hope of getting our data out of Heroku without some insane amount of downtime.

Please feel free to DM me should you need any tips with this. Email - me[at]rudimk.com.

Reply on news.ycombinator.com