Top
Enterprise Postgres 17 Installation and Setup Guide for Server

4.7.2 pg_bigm

4.7.2.1 Setting Up pg_bigm

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

  2. As superuser, run the following command:

    $ su -
    Password:******
    # cp -r /opt/fsepv<x>server64/OSS/pg_bigm/* /opt/fsepv<x>server64
  3. Restart Fujitsu Enterprise Postgres.

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

    postgres=# CREATE EXTENSION pg_bigm;
    CREATE EXTENSION

4.7.2.2 Removing pg_bigm

  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_bigm 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_bigm
  3. Set the postgresql.conf file parameters.
    Delete "pg_bigm" to the shared_preload_libraries parameter.

  4. Restart Fujitsu Enterprise Postgres.