When upgrading FUJITSU Enterprise Postgres 9.4 or newer database instances to FUJITSU Enterprise Postgres 10 or later using pg_upgrade, there are certain steps you need to follow.

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;