pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically required for major version upgrades, e.g., from 9.5.8 to 9.6.4 or from 10.7 to 11.2.
Source: https://www.postgresql.org/docs/12/pgupgrade.html
My related questions:
- So if there's this nice, sleek
pg_upgrade
tool to do this in a much nicer and quicker way, why would anyone ever want to go through the whole dump/restore ordeal? I never knew about the existence of this until recently, and now I feel "something" for wasting so much time and effort when I could've just done a simple command. - I'm not sure why they call it "dump/reload" here. Isn't it "dump/restore"?