If you are upgrading a database instance that uses the extensions, follow the procedure below to upgrade according to the source product version.

If you are using pg_upgrade to upgrade a database instance from FUJITSU Enterprise Postgres 10 or later that uses the extensions, follow the procedure below to 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.

If you use pg_upgrade to upgrade a FUJITSU Enterprise Postgres 9.x database instance that uses the extensions, perform the following steps.

Before using pg_upgrade, remove the following extensions from all databases in the instance, except "template0":

• pg_stat_statements

• pgx_io

• pgx_paging

• pgx_network

• pgx_network_err

• pgx_cpu

• pgx_memory

• pgx_swap

• pgx_disk

• pgx_process

• pgx_log

• oracle_compatible

• pg_dbms_stats

• pg_hint_plan

For all databases except "template0", execute the following command to remove these extensions:

DROP EXTENSION extensionName;

Once the pg_upgrade operation is complete, for all databases except "template0", execute the following command to re-create these extensions as required:

CREATE EXTENSION extensionName;