Skip to main content
Version 3.1.1

PostgreSQL Binary Directories Configuration

The Binary Directory (PGBIN) is the absolute path of the installation directory of a specific PostgreSQL version.

Usually, installations are done in the /usr/pgsql-VV directory, where VV represents the major version of PostgreSQL.

note

Although there are no restrictions on having other binaries of the same version in different directories, in the PostgreSYS platform, it is assumed that there is only one directory for a specific version.

Command Syntax
Terminal input
    pgsmart cluster config [Flags]

Flags:​

  • **-D, --pgdata=<path> [Default: data]. => data directory of the PostgreSQL instance.
  • **-M, --pgversion=(11|12|13|14|15). => major version of PostgreSQL.
  • -a, --agent= <agent>. => Alias, hostname, or IP 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

PostgreSQL Binary Directories Configuration.​

  1. Select the PgSmart Agent (or Register a new Agent).

  2. Select General Settings in the options menu.

  3. Select PostgreSQL Binary Directories in the options menu.

Upon selecting the "PostgreSQL Binary Directories" operation, the following actions are available:

  • List PostgreSQL Binary Directories: allows you to view the paths for existing PostgreSQL Binary Directories.
  • Edit a PostgreSQL Binary Directory: allows you to register or modify a PostgreSQL Binary Directory path.
  • Remove a PostgreSQL Binary Directory: removes a PostgreSQL binary directory path.

List PostgreSQL Binary Directories​

  1. Select the List option.

    note

    The list of PostgreSQL Binary Directories will be displayed.

    Figure 1 - Diretório de Binários - Lista
    Figure 1 - Diretório de Binários - Lista

Edit a PostgreSQL Binary Directory​

  1. Select the Edit operation.

  2. Select a PostgreSQL Version.

  3. Enter the Binary Directory Location and confirm the edit.

    Figure 2 - Diret�ório de Binários - Edição
    Figure 2 - Diretório de Binários - Edição

Remove a PostgreSQL Binary Directory​

  1. Select the Remove operation.

    note

    When selecting this action, PgSmart will provide a list of PostgreSQL Binary Directories.

  2. Select the PostgreSQL Binary Directory you want to remove.

  3. Confirm the removal of the PostgreSQL Binary Directory.

    Figure 3 - Diretório de Binários - Remove
    Figure 3 - Diretório de Binários - Remove