PgSmart Web Installation

Once the minimum requirements are met, we begin deploying the PostgreSYS Platform by installing the PgSmart component, which provides an intuitive guide for installing other components.

PgSmart Web is the graphical user interface (GUI) of the PostgreSYS Platform, allowing users to perform the same operations as the PgSmart CLI through a more intuitive browser-based interface.

Prerequisites

• PgSmart Agent Registration via PgSmart CLI on the machine where the WEB server will run.
• PgSmart CLI Installation, observing the minimum requirements.

PgSmart Web is installed through the PostgreSYS Environment Administration and Operation option in PgSmart CLI.

Command Syntax

Terminal input

    pgsmart install -s adm [Flags]

Terminal input

    pgsmart install --service=adm [Flags]

Flags:

• -a, --agent= <agent>. => Defines the alias, hostname or IP of the server where the PgSmart Agent is installed.
• -h, --help. => Displays help.
• -q, --quiet. => Non-interactive execution to install services. Used with --service, --pgversion, and --agent.
• -s, --service=adm. => Service for Administration and Operation of the PostgreSYS Environment

Non-Interactive Installation

This installation mode is triggered by the quiet option (--quiet, -q) and uses default values for unspecified parameters. However, this option is disabled during the first installation, as it requires creating the PostgreSYS package repository based on interactively provided information.

Instructions

Terminal input

    pgsmart install -a <agent> -q --service=adm

Figure 1 - PgSmart Web Installation - Non-Interactive

Video

Carregando...

Interactive Installation

Install

Terminal input

    pgsmart install

1. Select the PgSmart Agent (or Register a new Agent).
2. Select the Administração e Operação do Ambiente PostgreSYS.
3. Select the Cliente do PgSmart component.

3.1. If you did not select Base de Metadados do Ambiente PostgreSYS, specify whether to install an External Metadata Database.

• If not, the PostgreSYS Metadata Database will be installed.¹
• If yes, connection data will be configured in PgSmart Web.

3.2. Confirm default PostgreSYS repository installation or specify the desired repository URL, and Enter:

• Identification code.

• Repository name.

• Repository access user (optional for non-Tecnisys repositories).

• Repository access password (optional for non-Tecnisys repositories).

• Confirm whether to enable GPG key verification.

  • If yes, specify the GPG key file path.
  note

  • For a local installation, do not forget to download and import the public GPG key from the repositories (RPM-GPG-KEY-PGSYS). For example, for RHEL 8 distributions, access:

    File Path

        https://repo.tecnisys.com.br/repository/yum/pgsys/repos/4.0.0/rhel-8-x86_64/RPM-GPG-KEY-PGSYS
    • The compressed (tar.gz) component and utility packages already include the public GPG key.
  

  Figure 2 - PgSmart Web Installation - Interactive

Variations of the Interactive Installation Command

Some parameters can be passed in advance, but without the quiet option (--quiet, -q) the execution remains interactive and the values are used as defaults for the prompts.

Terminal input

    pgsmart install --service=adm

Terminal input

    pgsmart install --pgversion=17

note

• Installation status can be verified with:

Terminal input

  systemctl status pgsmart-web

• PgSmart Web status:

Terminal input

  pgsmart web client status

• PostgreSQL service status needed for the Metadata Database:

Terminal input

  pgsmart web database status

Access

Accessing PgSmart Web

1. In your browser, access the web via https (https://<IP where the service was installed>).

Example:

File Path

    https://192.168.56.236:4435/

2. Enter the user and password (on first access, you will be prompted to set and confirm a password).

Figure 1 - PgSmart Web Installation - Authentication

3. Configure the Authentication Method.

Figure 3 - PgSmart Web Installation - Authentication Method

note

At this initial setup stage of PgSmart Web, you can choose the authentication method:

• 🔐 Local Authentication

  • Credentials are securely stored in the platform's metadata database. Suitable for small or test environments.
  • No external services required.
  • User creation and management are manual via the system interface.

• 🏢 LDAP Authentication

  • LDAP (Lightweight Directory Access Protocol) is used to access and manage directory services like Active Directory.
  • Integrates with corporate directories, allowing centralized authentication.
  • Users use the same credentials as in other systems.
  • Supports Active Directory and other LDAP services.
  • Centralized credential management.
  • Ideal for organizations with established identity control.

  Notes:

  1. Regardless of the method, all users are registered in the metadata database for audit and profile control.
  2. When LDAP is used, the first login creates a user record with the given login and default "Analyst" profile.
  3. It's possible to switch a registered user between local or LDAP authentication.

Welcome to PgSmart Web!

Figure 4 - PgSmart Web Installation - Initial Screen

note

PgSmart Web includes a Guided Tutorial — an interactive feature that walks you through all PostgreSYS functionalities, from initial setup to full service administration. With an intuitive interface, it's especially helpful for those new to the PostgreSQL ecosystem.

Video

Carregando...

Footnotes

1. The metadata database allows editing of certain metadata (user registration, environments, repositories, agent records, etc.). All changes are stored in the database. ↩