Top
Enterprise Postgres 14 SP1 Installation and Setup Guide for Server
FUJITSU Software

4.6.7 pg_statsinfo

4.6.7.1 Setting Up pg_statsinfo

  1. Set the postgresql.conf file parameters.

    • Add "pg_statsinfo" to the shared_preload_libraries parameter.

    • Specify the log file name for the log_filename parameter.

  2. As superuser, run the following command:

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

Information

Note that pg_statsinfo forcibly overwrites the settings below.

  • log_destination

    "csvlog" is added and "stderr" is deleted.

  • logging_collector

    "on" is set.

Note

This feature cannot be used on instances created in WebAdmin. It can only be used via server commands.

4.6.7.2 Removing pg_statsinfo

  1. 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_statsinfo
  2. Set the postgresql.conf file parameters.

    • Delete "pg_statsinfo" to the shared_preload_libraries parameter.

    • Delete the log file name for the log_filename parameter.

  3. Restart FUJITSU Enterprise Postgres.