The Coding Interface personal blog

Migrating Large Heroku Postgres Instances to AWS Aurora Without Downtime

thecodinginterface.com

In this article I discuss a general process I used recently to migrate a large multi-terabyte Heroku Postgres Database from the Heroku Platform to Amazon Aurora Postgres on a live Heroku based application architecture with near zero downtime and builtin failover during the process.

Points

124

HN comments

39

Submissions

1

Cited by

0 commenters

Databases & DataInfrastructure & DevOps2020

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

Pphiresky20211,812 points314 commentscited by 26 details

Personal and social information of 1.2B people discovered in data leak

Data Viper Blog20191,439 points419 comments details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

CRDTs are the future

Joseph Gentle20201,181 points357 commentscited by 12 details

Things I wished more developers knew about databases

Jaana Dogan20201,011 points445 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details