Skip to main content
Version 4.0

Authorized Users Configuration

Defines the database users allowed to connect through the connection pool.

Command Syntax
Terminal input
    pgsmart pool config [Flags]

Flags:​

  • -a, --agent=<agent> => Alias, hostname, or IP of the server where the desired PgSmart Agent is installed.
  • -h, --help => Help.
  • -q, --quiet => Non-interactive execution. Results are recorded in the PgSmart Client log. Used along with the --agent option.
Non-Interactive Configuration

Non-interactive execution is disabled for this operation.

Interactive Configuration

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

  2. Select the "Authorized Users" section (selection made using the [space] key).

When selecting the Authorized Users section, the following operations are available:

  • Listar — Allows listing configured authorized users
  • Adicionar — Allows adding a new authorized user
  • Editar — Allows editing an authorized user
  • Remover — Allows removing an authorized user

List configured authorized users​

  1. Select the Listar operation.

    Figure 1 - Connection Pool Configuration - Listar Users
    Figure 1 - Connection Pool Configuration - Listar Users
note

The list of already configured authorized users will be displayed.

Add a new Authorized User​

  1. Select the Adicionar operation.

  2. Enter the database connection user.

  3. Enter the user’s password.

  4. Select the connection reuse mode.

  5. Enter the maximum number of pool connections for this user (optional).

  6. Confirm the user addition.

    Figure 2 - Connection Pool Configuration - Add Users
    Figure 2 - Connection Pool Configuration - Add Users

Edit an Authorized User​

  1. Select the Editar operation.

  2. Select the User to edit.

  3. Update the connection username.

  4. Update the user’s password.

  5. Update the connection reuse mode.

  6. Update the maximum number of connections for this user in the pools [optional].

  7. Confirm the changes.

    Figure 3 - Connection Pool Configuration - Edit Users
    Figure 3 - Connection Pool Configuration - Edit Users

Remove an Authorized User​

  1. Select the Remover operation.

  2. Select the user to remove.

  3. Confirm the user removal.

    Figure 4 - Connection Pool Configuration - Remove Users
    Figure 4 - Connection Pool Configuration - Remove Users
note

Authorized user verification occurs at connection time.