Installing Updates
The PostgreSQL database is constantly evolving. As a PostgreSQL administrator, you will occasionally need to upgrade an existing database to a new release. Fortunately, upgrading an existing database is usually a simple process.
In most cases, the only work required to move to a new release is to dump the entire database cluster (using pg_dumpall), install the new software, and restore from the dump. Installing a new release this way is nearly identical to performing a backup and restore operation. For some upgrade paths, you don't even need to dump/restore—the new release includes a pg_upgrade utility that upgrades your data in place.
Get PostgreSQL, 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.
