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.
[ Parent
| on HN ]
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.