One day I’ll figure out how to do a zero-downtime Postgres upgrade
@betsybookworm you know I have key art for a mascot for this, I just haven't gotten around to ... using it ...
@aurynn from memory zero downtime PostgreSQL upgrades is basically “have two or more databases that replicate between them”, then upgrade replica and switch the primary.
If the database dump and reload takes less than several minutes I’d probably just schedule downtime TBH.
@ewenmcneill dump/reload won't take very long, I'll be doing that.
I don't think I need to engineer for a replicated database until we get significantly more userbase
A paid, early access, strongly moderated Mastodon instance hosted entirely in Aotearoa New Zealand.