News for hackers. Stuff that matters.

A comment on Why Does Everyone Run Ancient Postgres Versions?. Parent comment

Re:Why Does Everyone Run Ancient Postgres Versions? by literalAardvark on Friday October 18, 2024 @08:49AM (#41878946)
just as long as you don't forget to reindex after
[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by mxey on Friday October 18, 2024 @09:50AM (#41879466)
> All failure, rebuild, and reindex cases will be reported by pg_upgrade if they affect your installation; post-upgrade scripts to rebuild tables and indexes will be generated automatically.
[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by literalAardvark on Friday October 18, 2024 @03:31PM (#41882680)
Not true. Those scripts only cover problems caused by PostgreSQL itself, not, for example, a change in collations that will silently break your indexes, such as the one in Debian 12.
[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by djbusby on Friday October 18, 2024 @10:55AM (#41880017)
It's a step of your script or runbook. Right?
[ Parent | on HN ]
Re:Why Does Everyone Run Ancient Postgres Versions? by literalAardvark on Friday October 18, 2024 @03:29PM (#41882655)
It is, but it also takes a very long time during which production data integrity can be severely affected.
[ Parent | on HN ]