Skip to main content
Version 3.1.1

Connection Pool Installation

To activate the connection pool, PgSmart integrates with PgBouncer.

Prerequisites

  • PgSmart installation, meeting the minimum requirements.

  • Repository of additional packages to resolve indirect dependencies. In accordance with the security and support policies of each organization, Tecnisys does not provide such packages. However, to assist you, we would like to inform you that for distributions in the Enterprise Linux family, the Extra Packages for Enterprise Linux - EPEL generally provide the necessary indirect dependencies.

  • Start the PgSmart Agent service on all machines in the database environment.

    Terminal input
        systemctl start pgsmart-agent

  • Log in as the PgSmart local user. For example:

    Terminal input
        su - PgSmart

  • PgSmart Agent Registry via the PgSmart client.

Command Syntax
Terminal input
    pgsmart install -s pool [Flags]
Terminal input
    pgsmart install --service=pool [Flags]

Flags:​

  • -M, --pgversion=(11/12/13/14/15). Default: 15. => major version of PostgreSQL, regardless of the service. The latest release of the selected major version will be used.
  • -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 installing services. Used with --service, --pg-major-version and --agent.
  • --pg-major-version=(11|12|13|14|15) [Default:15]. => Major base version of PostgreSQL, independent of the service. The latest release of the selected major version will be used.
Non-Interactive Installation

This installation mode is enabled by the quiet option (--quiet, -q) and its execution uses default values for unspecified parameters. However, this option is disabled during the first installation due to the need to create the PostgreSYS package repository based on information requested interactively.

Terminal input
  pgsmart install -q -a <value> --service=pool --pg-version=(11|12|13|14|15)
Figure 1 - Pool Installation - Non Interactive
Figure 1 - Pool Installation - Non Interactive
Interactive installation
Terminal input
  pgsmart install

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

  2. Select Connections Pool service.

  3. Select the Major version of environment PostgreSQL.

  4. Select the 'Release` of the environment PostgreSQL Major Version.

  5. Confirm the installation:

  6. Confirm that you want to download the package repository and, if prompted, the URL of the repository.

    note

    This question is not asked if the pgsys-utils repositories are already present or mapped on the machine.

    Figure 2 - Pool Installation - Interactive
    Figure 2 - Pool Installation - Interactive

Command Variations for Interactive Install​

Some parameters can be passed in advance in the command; however, without the quiet option (--quiet, -q), the execution remains interactive, with these parameters being used with the default values in the prompts.

Examples:

Terminal input
      pgsmart install --service=pool
Terminal input
      pgsmart install --pg-version=15
Final Notes
note

PgSmart sets environment variables (PGDATA, PGBIN, among others) in the current user's bash_profile file that will be loaded in new sessions. If you want to load these variables immediately, execute the command below after the installation:

Terminal input
    source ~/.bash_profile