At GoCardless, we use Postgres as the primary store for data that matters - records of merchants, customers and payments.
As a payments API, it's important to our users that we maintain a high level of uptime. At the same time, we believe that performing upgrades is an important reality of running software in production - databases included. Even the most stable software has critical bugs from time to time, and you have to deploy patches.
When it came to Postgres, we found ourselves caught between our desire to minimise downtime and our need to keep our software stack up-to-date. Postgres doesn't ship with all the machinery you need to do zero-downtime upgrades, so we knew we had work to do.
In the talk, we'll look at the problems faced when trying to upgrade Postgres without downtime, and explore our approach to building automation to upgrade Postgres without the apps noticing.
sinjo
kin29
coa00
a4lg
usualoma
yuya4
utgwkk
star_zero
77web
kubode
cocoeyes02
shgishzk
kubotak
bluesmoon
cromwellryan
robhawkes
afnizarnur
jonyablonski
addyosmani
dotmariusz
lynnandtonic
jasonvnalue
mclloyd
roundedbygravity
colly