PostgreSQL provides an additional supplied program, called pg_upgrade
, which allows you to migrate between major releases, such as from 9.2 to 9.6; alternatively, you can upgrade straight to the latest server version. These upgrades are performed in-place, meaning that we upgrade our database without moving to a new system. That does sound good, but pg_upgrade
has a few things that you may wish to consider as potential negatives, which are as follows:
- The database server must be shut down while the upgrade takes place.
- Your system must be large enough to hold two copies of the database server:
old and new copies. If it's not, then you have to use the
link
option ofpg_upgrade
, or use the Major upgrades online recipe later. If you use thelink
option onpg_upgrade
, then there is nopg_downgrade
utility. The only option in that case is a restore from backup, and that means extended unavailability while you restore. - If you copy the database, then the upgrade time will be...