1. Set the postgresql.conf file parameters.
   Add "pg_hint_plan" to the "shared_preload_libraries" parameter.

2. As superuser, run the following command:

   $ su -
   Password:******
   # cp -r /opt/fsepv<x>server64/OSS/pg_hint_plan/* /opt/fsepv<x>server64

3. Restart Fujitsu Enterprise Postgres.

4. Run CREATE EXTENSION for the database that uses this feature.
   The target database is described as "postgres" here.
   Use the psql command to connect to the "postgres" database.

   postgres=# CREATE EXTENSION pg_hint_plan;
   CREATE EXTENSION

   See

   Refer to "Enhanced Query Plan Stability" in the Operation Guide for details.

Unsetting pg_hint_plan will cause hints registered in the hint_plan.hints table to be lost. Therefore, if you might later use pg_hint_plan again, back up each database's hint_plan.hints table with pg_dump before unsetting it up.

1. Execute DROP EXTENSION for the database that will use this feature.
   Use the psql command to connect to the "postgres" database.

   postgres=# DROP EXTENSION pg_hint_plan CASCADE;
   DROP EXTENSION

2. As superuser, run the following command:

   $ su -
   Password:******
   # rm -rf /opt/fsepv<x>server64/filesCopiedDuringSetup

   Information

   The files copied during setup can be checked below.

   # find /opt/fsepv<x>server64/OSS/pg_hint_plan

3. Set the postgresql.conf file parameters.
   Delete "pg_hint_plan" to the shared_preload_libraries parameter.

4. Restart Fujitsu Enterprise Postgres.