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.
As superuser, run the following command:
$ su - Password:****** # cp -r /opt/fsepv<x>server64/OSS/pg_statsinfo/* /opt/fsepv<x>server64
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.
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
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.
Restart FUJITSU Enterprise Postgres.