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.
Or do you mean the new Pg server should transparently do the upgrade automatically? And while online?