Skip to main content
Version 3.1

Connection Pool Management

Check out the commands needed to configure the connection pool in the PostgreSQL ecosystem:

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

Operations:

  • Display the status of the connection pool.
  • Initialize the connection pool service.
  • Stop the connection pool service.
  • Restart the connection pool service.
  • Reload the services of the connection pool components.

Flags:

  • -a, --agent=<agent> => Alias, hostname, or IP of the server where a PgSmart Agent is installed
  • -h, --help => Help
  • -q, --quiet => Non-interactive execution for controlling the connection pool service (status|start|stop|restart|reload)
Non-Interactive Execution
Terminal input
pgsmart pool [status|start|stop|restart|reload] -q -a <value>
Interactive Execution

Display the status of the connection pool​

Terminal input
pgsmart pool status

Stop the connection pool service​

Terminal input
pgsmart pool stop

Initialize the connection pool service​

Terminal input
pgsmart pool start

Restart the connection pool service​

Terminal input
pgsmart pool restart

Reload the services of the connection pool components​

Terminal input
pgsmart pool reload