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.

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.

The following describes the tasks required to upgrade a database instance of FUJITSU Enterprise Postgres 9.x using the extension with pg_upgrade.

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

Before running pg_upgrade, remove the following extensions from all databases of the instance, except for "template0". If a column was created in the user table using the following extended data types, "DROP EXTENSION" will also drop that column:. In such cases you might need to consider alternative upgrade methods rather than pg_upgrade. In that case, consider using pg_dump or pg_restore.

• 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;