Ever since there's pg_upgrade available. Since 8.4 or so - https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using

Ever since there's pg_upgrade available. Since 8.4 or so - https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/ https://www.percona.com/blog/2019/04/12/fast-upgrade-of-lega... Dump and reload is ok if you have a small database or can afford hours of downtime... if not, use pg_upgrade.