Skip to main content
Version 3.1.0

Observability Service Installation

In PostgreSYS, the Observability service is implemented through the integration of Prometheus, Grafana, Alertmanager, and Karma components, which are responsible for collecting, storing, and displaying metrics and alerts for the entire PostgreSQL database environment.

Prerequisites

  • PgSmart installation, observing the minimum requirements.

  • Extra package repository to resolve indirect dependencies. In accordance with each organization's security and support policies, Tecnisys does not provide these packages. However, to assist you, we inform you that for Enterprise Linux family distributions, the Extra Packages for Enterprise Linux - EPEL repository generally provides the necessary indirect dependencies.

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

    Terminal input
    systemctl start pgsmart-agent

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

    Terminal input
    su - PgSmart

  • PgSmart Agent Registration via PgSmart-Client.

Command Syntax
Terminal input
pgsmart install -s obs
Terminal input
pgsmart install --service=obs

Flags:​

  • -M, --pgversion=(11/12/13/14/15). Default: 15. => Major version of PostgreSQL, regardless of the service. The latest release of the chosen 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 service installation. Used together with --service, --pg-major-version and --agent.
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 192.168.0.102 --service obs --pgversion=16
Figure1 -Observability Installation - Non interactive
Figure1 -Observability Installation - Non interactive
Interactive Installation
Terminal input
pgsmart install

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

  2. Select the Observability 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. 6.1 Provide the package repository URL.

    note

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

    Figure2 -Observability Installation - interactive
    Figure2 -Observability Installation - interactive

Command Variations for Interactive Installation​

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 --service=pool --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