Giving your Heroku App highly-available PostgreSQL

on YouTube ↗11m

" summary

Explains how a Compose / IBM Cloud HA PostgreSQL setup uses etcd plus a Governor/Patroni-style coordinator with HA proxy and WAL streaming to keep leader/follower nodes synced, then walks through the exact migration: grab a Heroku PG backup, pg_restore into the IBM Cloud connection string (nonstandard port), remove the Heroku Postgres add‑on so DATABASE_URL can be reset, set DATABASE_URL to the new host, verify in console; data copy is online, the config‑var switch causes the only brief downtime.

AI-written summary · about

" chapters (9)

1. 0:00High-availability PostgreSQL intro
2. 1:25IBM Cloud PostgreSQL HA
3. 2:57Demo setup and backup
4. 4:00Restore to IBM Cloud PostgreSQL
5. 5:29Heroku config for new instance
6. 7:02Migrate data and final checks
7. 8:33Downtime and sync handling
8. 9:38Elasticsearch integration
9. 10:43Summary

" related talks

• 47mBreakout SessionGreg Beruk · PGConf Silicon Valley 2015
• 33mHerding ElephantsClint Shryock · Big Ruby 2014
• 46mDeploying Maximum HA Architecture With PostgresDenish Patel · Postgres Open 2012
• 01h 00mWriting Portable PostgreSQL - backed network applications for the open cloudRyan Jarvinen · PostgresOpen 2013
• 47mPostgreSQL High Availability: The Considerations and the CandidatesHamid Quddus Akhtar · Percona Live 2022
• 53mBest practices of using a managed PostgreSQL in the cloudJignesh Shah · PostgresOpen Silicon Valley 2017
• 55mHigh Availability with PostgreSQL and PacemakerShaun M. Thomas · Postgres Open 2012
• 50mThe Immortal Postgres WebShaun Thomas · PostgresOpen Silicon Valley 2017