Skip to main content
Version Next

PostgreSQL Binary Directory Configuration via PgSmart Web

The Binary Directory (PGBIN) refers to the absolute path where a specific PostgreSQL version is installed.

Typically, installations are located in the directory /usr/pgsql-VV, where VV is the major version of PostgreSQL.

note

Although multiple binaries of the same version can exist in different directories, PostgreSYS assumes a single directory per version.

  1. In the side menu, select the Banco de Dados option.

  2. Select the desired Environment from the dropdown in the top bar.

  3. Go to the Binários tab.

    Figure 1 - Binary tab selection
    Figure 1 - Binary tab selection

Add a Binary Directory

  1. To add a binary directory:
    1.1. In the Hosts list, select the desired server.
    1.2. In the PostgreSQL version list, click the edit icon ✏ in the Actions column next to the desired entry.
    1.3. Enter the binary directory to be added.
    1.4. Click Salvar.

    Figure 2 - Add Binary Directory option
    Figure 2 - Add Binary Directory option
    Figure 3 - Registering the new binary directory
    Figure 3 - Registering the new binary directory

Remove a Binary Directory

  1. To remove a binary directory:
    1.1. In the PostgreSQL version list, click the delete icon 🗑 in the Actions column next to the desired entry.
Figure 4 - Remove Binary Directory
Figure 4 - Remove Binary Directory