Hacker News new | ask | show | jobs
by october8140 925 days ago
Heroku just does this. At my old job we would scale the database using replication multiple times a week depending on expected traffic.

https://devcenter.heroku.com/articles/heroku-postgres-follow...

2 comments

Not quite I don't think. For a busy database, The Heroku followers will not catch up to your upgraded database as quickly, so during an upgrade using Heroku's physical replication (as opposed to logical), there will be a time period where your freshly upgraded primary is on its own as the followers are being issued and brought up to date.
Except Heroku has an issue of your backup etc is too large (despite paying for the correct size), it would cause the replica to go down and spin up a new one, and this process could take hours.