Performing a Major PostgreSQL Upgrade with pg_dumpall

November 26, 2018

PostgreSQL Upgrading

For most major upgrades using a utility such as pg_upgrade or a replication tool such as pglogical will be the best solution. However if these options are not available, pg_dumpall can be used to perform a major upgrade. What follows is a guide on how you can safely upgrade your database to a newer version of PostgreSQL with pg_dumpall.