Top
Enterprise Postgres 17 SP1 Operation Guide

1.6 Notes on Upgrading Database Instances

If you use pg_upgrade to upgrade a Fujitsu Enterprise Postgres database instance that uses the extensions, follow the procedure below to upgrade.

It is strongly recommended to back up the database using pg_dump before performing pg_upgrade.

  1. Create a database cluster at the destination

  2. Stop the source and destination instances

  3. Run the pg_upgrade command

  4. Start the destination instance

  5. Update the extensions used with ALTER EXTENSION to the latest version at the destination

    ALTER EXTENSION extensionName UPDATE;

    If you are using multiple extensions, please update each extension separately.

See

For information about pg_upgrade and ALTER EXTENSION, refer to "Reference" in the PostgreSQL Documentation.