News for hackers. Stuff that matters.

A comment on PostgreSQL upgrades are hard. Parent comment

Re:PostgreSQL upgrades are hard by wutwutwutwut on Saturday June 25, 2022 @06:48AM (#31874175)
Yes, if the software I work on doesn't work for 5 minutes we have a ton of tickets from customer. We have tens of thousands of customers who pay for it. Not being able to shut down your system for an hour isn't exactly a unique requirement. Technically our SLA is 10 minutes to perform jobs but our customers don't wait that long before creating tickets.

We pay Microsoft to perform upgrades transparently for us. They have multiple servers and they shuffle transaction logs and traffic between them to ensure availability during outages and upgrades. There are 6 copies of each database in different regions. Not sure how that is relevant, though?

[ Parent | on HN ]
Re:PostgreSQL upgrades are hard by mrelectric on Saturday June 25, 2022 @07:00AM (#31874237)
It is relevant, reread and understand the parent comment. Get a managed pg and you'll have the same thing.
[ Parent | on HN ]
Re:PostgreSQL upgrades are hard by rmbyrro on Saturday June 25, 2022 @07:53AM (#31874469)
That's the point.

It's not a weakness in Postgres.

Managing upgrades in a highly available, close to 100% uptime database is hard.

If you want piece of cake, outsource this service and be happy enjoying the database features working as you please.

[ Parent | on HN ]
Re:PostgreSQL upgrades are hard by mrelectric on Sunday June 26, 2022 @06:54PM (#31888886)
Yes, that's what I was saying :)
[ Parent | on HN ]
Re:PostgreSQL upgrades are hard by wutwutwutwut on Saturday June 25, 2022 @07:13AM (#31874298)
I believe you are the one who need to reread the thread. The person I replied to claimed that "Postgresql upgrades are a piece of cake."

But it is not. It's complex to do properly, just like with most if not all other databases. Claiming that it is easy as is just ignorant and spreading such misinformation is bad.

[ Parent | on HN ]
Re:PostgreSQL upgrades are hard by mrelectric on Sunday June 26, 2022 @06:57PM (#31888919)
I never claimed it's easy, I just said get a managed pg, offload it to someone else and then it's easy yeah. I'm wondering the same as other commentator above me, what's the difference in other unmanaged dbs?
[ Parent | on HN ]