O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Major upgrades in-place

New in PostgreSQL 9.0 is a utility named pg_upgrade, supplied as a contrib module. pg_upgrade allows you to migrate to new major versions of PostgreSQL, such as from 8.4 to 9.0, or from 9.0 to 9.1.

In-place upgrades means upgrading your database without moving to a new system. That does sounds good, though pg_upgrade has a few things that you may wish to consider as potential negatives, which are as follows:

  • Database server must be shut down while upgrade takes place.
  • Your system must be big 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 recipe on upgrading using replication tools. If you use the link option on pg_upgrade, then ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required