News for hackers. Stuff that matters.
Re:PostgreSQL upgrades are hard by forinti on Saturday June 25, 2022 @08:51AM (#31874887)
I'm curious as to what could have gone wrong. A few weeks ago I upgraded from 9 to 14 using pg_upgrade and had no issue whatsoever.
Re:PostgreSQL upgrades are hard by nicoburns on Saturday June 25, 2022 @03:44PM (#31878120)
I think the issue is if you want zero-downtime (or close to zero downtime). pg_upgrade can take upwards of 10 minutes to run even for relatively small databases. It can potentially be hours for large ones.
Re:PostgreSQL upgrades are hard by aidos on Sunday June 26, 2022 @06:37AM (#31882662)
If you use —-link it uses the existing data files instead of copying, which is significantly faster (though I’m not sure what your definition of relatively small is).
Re:PostgreSQL upgrades are hard by Macha on Saturday June 25, 2022 @09:27AM (#31875131)
Doesn't this entail going 9.4-10, 10-11, 11-12, 12-13 and 13-14? (and possibly across various 9.x versions)

That would be enough to qualify as "super painful" for me

Re:PostgreSQL upgrades are hard by forinti on Saturday June 25, 2022 @09:38AM (#31875209)
No. To be precise, it was 9.6.6 or 9.5.3 (I don't recall which one exactly because both were installed) to 14.0. And then I upgraded to 14.4, but that only required a compilation.