Chapter 51. Instance Parameters

Table of Contents

51.1. Viewing Instance Parameters
51.2. Editing Instance Parameters

PPEM allows viewing and editing parameters of the DBMS instance.

The ALTER SYSTEM command is used to modify instance parameters. It modifies the postgresql.auto.conf file.

If an instance parameter was initially specified in the main configuration file, such as postgresql.conf, but later changed via PPEM and written to postgresql.auto.conf, the web application will display this parameter in both files. This is normal because values from postgresql.auto.conf take precedence over other configuration files.

PPEM uses the pg_reload_conf() function to apply instance parameters without restarting the instance.