Major upgrades in-place
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:
- 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 of
pg_upgrade, or use the Major upgrades online recipe later. If you use ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
