News for hackers. Stuff that matters.
Re:PostgreSQL upgrades are hard by technion on Saturday June 25, 2022 @06:11AM (#31874002)
Not that I want to defend Oracle but I've been through the process of installing a new version, starting it up whilst loading the same database files currently being served by an older patch level, and seeing it fail over to the new version without dropping in flight queries. They've always done pretty well in this space in my view.

Of course, you've still got to obtain a patch. I usually see the licensing in the name of some senior manager who doesn't know how to use a keyboard and who is also the only person allowed to download patches.

Re:PostgreSQL upgrades are hard by Spooky23 on Saturday June 25, 2022 @07:13AM (#31874299)
You have to do that because Oracle has a nasty habit of changing what’s in the download and then changing the licensing scheme.

I’ve been burned by this before, and gone as far as to require a 3rd party audit for Oracle installations on a quarterly basis.

Re:PostgreSQL upgrades are hard by forinti on Saturday June 25, 2022 @07:33AM (#31874376)
Are you referring to updating one node at a time of a RAC cluster or is that some other method?
Re:PostgreSQL upgrades are hard by technion on Saturday June 25, 2022 @08:06AM (#31874540)
Yes that is what I'm referring to. But note Oracle has the concept of a single node cluster, so you can have a completely standalone deployment and still perform this technique hot adding a new "node" when it's the same server.