PostgreSQL provides an Additional Supplied Program, called
pg_upgrade, that allows you to migrate between major releases, such as from 9.1 to 9.2; or you can upgrade straight to the latest server version. These upgrades are performed in-place, meaning that we upgrade your 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:
pg_upgrade, or use the Major upgrades online recipe later. If you use ...