Skip to main content
Version 3.1.0

Database Instance Parameter Configuration

Given an already created instance (Cluster Initialization), the next step is to configure its parameters, an action that modifies the data of the postgresql.conf file, present in the cluster directory.

The parameters available for editing comply with the installed and selected PostgreSQL version.

Every change made includes a comment line in the postgresql.conf file with the date and user who made the change.

Prerequisites
Command Syntax
Terminal input
pgsmart cluster config [Flags]

Flags:​

  • **-D, --pgdata=<path> [Default: data]. => PostgreSQL instance Data Directory.
  • **-M, --pgversion=(11|12|13|14|15). => Majority version of PostgreSQL.
  • -a, --agent= <agent>. => Alias, hostname or IP of the server where the desired PgSmart Agent is installed.
  • -h, --help. => Help
Non-Interactive Configuration

Non-interactive execution is disabled for this operation.

Interactive Configuration
Terminal input
pgsmart cluster config

Cluster Parameter Configuration​

  1. Select the desired PgSmart Agent or Register a new one.

  2. Select "Instance settings" from the options menu.

  3. Select the PostgreSQL instance Data Directory for which you want to configure the Parameters.

  4. Select the "Parameters" operation

    note

    When selecting the "Parameters" option, the list of configurable parameters will be available.

  5. Select the desired parameter.

  6. Confirm the modification of the selected parameter.

  7. Enter the new value for the parameter.

  8. Confirm if you wish to select another parameter. (If so, steps 5 onwards will be repeated)

  9. Confirm the operation

    Figure 1 -Cluster Parameters Configuration
    Figure 1 -Cluster Parameters Configuration
Final Notes
note

  • Depending on the modified parameter, a RELOAD or a RESTART of the instance may be necessary. PgSmart will inform which action is required to effect the change of the parameter.

  • If the Reload or Restart is not confirmed, the configuration will remain in the file until the necessary action is taken.