Skip to main content
Version 3.1.1

Authorized Users Configuration

Identifies which database users are authorized for connection through the connection pool.

Command Syntax
Terminal input
pgsmart pool config [Flags]

Flags:​

  • -a, --agent=<agent> => Alias, host name or IP of the server where the PgSmart Agent is installed.
  • -h, --help => Help.
  • -q, --quiet => Non-interactive execution. You can view the operation results in PgSmart Client log. Used together with --agent.
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 is made with the [spaces] key).

Upon selecting the Authorized Users Section, the following operations are made available:

  • List the already configured authorized users.
  • Add a new authorized user.
  • Edit an authorized user.
  • Remove an authorized user.

List Already Configured Authorized Users​

  1. Select the List option.
Figure 1 - Connection Pool - Users -List
Figure 1 - Connection Pool - Users -List
note

The list of already configured authorized users will be presented.

Add a New Authorized User​

  1. Select the Add option.

  2. Provide the database connection user.

  3. Provide the password of the database connection user.

  4. Provide the connection reuse mode.

  5. Provide the maximum number of connections for this user in the Connection Pools. [optional].

  6. Confirm the addition of the user.

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

Edit an Authorized User​

  1. Select the Edit option.

  2. Select the user you wish to edit.

  3. Provide the database connection user.

  4. Provide the password of the database connection user.

  5. Provide the connection reuse mode.

  6. Provide the maximum number of connections for this user in the Connection Pools. [optional].

  7. Confirm the edition of the user.

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

Remove an Authorized User​

  1. Select the Remove operation.

  2. Select the user you wish to remove.

  3. Confirm the deletion of the user.

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

Verification of authorized users will occur at the time of connection.