Skip to main content
Version Next

Connection Pool Management

Below are the commands available for managing the Connection Pool service within the PostgreSQL ecosystem.

Command Syntax
Terminal input
    pgsmart pool [OPERATION] [Flags]

Operations:

  • Status — Allows displaying the status of the connection pool
  • Start — Allows starting the connection pool service
  • Stop — Allows stopping the connection pool service
  • Restart — Allows restarting the connection pool service
  • Reload — Allows reloading the services of the connection pool components

Flags:

  • -a, --agent=<agent> => Alias, hostname or IP of the server where the desired PgSmart Agent is installed.
  • -h, --help => Help.
Interactive Execution

Show connection pool status​

Terminal input
    pgsmart pool status
Figure 1 - Connection Pool - Status
Figure 1 - Connection Pool - Status

Stop the connection pool service​

    bash title="Terminal input"
    pgsmart pool stop

  • Select the desired PgSmart Agent (or Register new Agent).

    Figure 2 - Connection Pool - Stop
    Figure 2 - Connection Pool - Stop

Start the connection pool service​

    bash title="Terminal input"
    pgsmart pool start

  • Select the desired PgSmart Agent (or Register new Agent).

    Figure 3 - Connection Pool - Start
    Figure 3 - Connection Pool - Start

Restart the connection pool service​

    bash title="Terminal input"
    pgsmart pool restart

  • Select the desired PgSmart Agent (or Register new Agent).

    Figure 4 - Connection Pool - Restart
    Figure 4 - Connection Pool - Restart

Reload the connection pool service​

    bash title="Terminal input"
    pgsmart pool reload

  • Select the desired PgSmart Agent (or Register new Agent).

    Figure 5 - Connection Pool - Reload
    Figure 5 - Connection Pool - Reload