Skip to main content
Version Next

PostgreSQL Binary Directory Configuration

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

Typically, installations are performed under the /usr/pgsql-VV directory, where VV corresponds to the PostgreSQL major version.

note

Although there are no restrictions for having binaries of the same version in different directories, for the PostgreSYS platform, it is understood that there should be only one directory per major version.

Command Syntax
Terminal input
    pgsmart db config [Flags]

Flags:​

  • -D, --pgdata=<path> [Default: data]. => PostgreSQL instance data directory.
  • -M, --pgversion=(11|12|13|14|15|16|17). => PostgreSQL major version.
  • -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 db config

PostgreSQL Binary Directory Configuration​

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

  2. Select Configurações dos Diretórios from the options menu.

  3. Select Diretórios de Binários PostgreSQL from the options menu.

When selecting the Diretórios de Binários PostgreSQL operation, the following options will be available:

  • Listar: Allows viewing the paths of already existing PostgreSQL binary directories.
  • Editar: Allows registering or editing a PostgreSQL binary directory path.
  • Remover: Removes a PostgreSQL binary directory path.

List PostgreSQL Binary Directories​

  1. Select the Listar option.
note

The list of registered PostgreSQL Binary Directories will be displayed.

Figure 1 - Binary Directory - List
Figure 1 - Binary Directory - List

Edit a PostgreSQL Binary Directory​

  1. Select the Editar operation.

  2. Select a PostgreSQL Version.

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

Figure 2 - Binary Directory - Edit
Figure 2 - Binary Directory - Edit

Remove a PostgreSQL Binary Directory​

  1. Select the Remover operation.
note

PgSmart will present a list of the registered PostgreSQL Binary Directories.

  1. Select the PostgreSQL Binary Directory you wish to remove.

  2. Confirm the removal.

Figure 3 - Binary Directory - Remove
Figure 3 - Binary Directory - Remove