News for hackers. Stuff that matters.
Re:Why Does Everyone Run Ancient Postgres Versions? by paulryanrogers on Friday October 18, 2024 @10:21AM (#41879746)
Does pg_upgrade not do all that?

Or do you mean the new Pg server should transparently do the upgrade automatically? And while online?

Re:Why Does Everyone Run Ancient Postgres Versions? by jeltz on Saturday October 19, 2024 @06:22AM (#41886933)
Yes, and it does it by starting an instance of the old version and runs pg_dump against it. And that was one thing the original poster complained about.
Re:Why Does Everyone Run Ancient Postgres Versions? by paulryanrogers on Sunday October 20, 2024 @01:17PM (#41896911)
Are pg_upgrade's docs inaccurate?

It says it works "without the data dump/restore" and...

> Major PostgreSQL releases regularly add new features that often change the layout of the system tables, but the internal data storage format rarely changes. pg_upgrade uses this fact to perform rapid upgrades by creating new system tables and simply reusing the old user data files

Regardless, I suppose it is that reliance on the unchanging of the internal data format which is limiting what refactors can do.