News for hackers. Stuff that matters.
Re:PostgreSQL upgrades are hard by hoffs on Saturday June 25, 2022 @12:35PM (#31876628)
How happy are you when your global bank has downtime in middle of the day?
Re:PostgreSQL upgrades are hard by PhineasRex on Saturday June 25, 2022 @01:03PM (#31876847)
You wouldn't schedule downtime for the middle of the day. You schedule downtime during your period of least usage.
Re:PostgreSQL upgrades are hard by fmajid on Saturday June 25, 2022 @03:26PM (#31877983)
You design the complete system so it does not have dependencies on a single component, that way each subsystem can have proper maintenance schedules. It takes a lot more up-front work, along with defining what levels of service degradation are acceptable during a window, but that's the difference between a professionally run service and one run by amateurs. Look up Google's SRE methodology and their concept of error budget.