Skip to main content
Version 3.1.0

Backup Management Service Installation

The component of the PostgreSQL ecosystem that PgSmart integrates with to perform Backup and 'Restore' operations is pgBackRest.

Prerequisites

  • PgSmart Installation, meeting the minimum requirements .

  • Extra package repository to resolve indirect dependencies. In accordance with the security and support policies of each organization, Tecnisys does not provide such packages. For the Enterprise Linux family distributions, the Extra Packages for Enterprise Linux - EPEL repository generally provides the necessary indirect dependencies.

  • PgSmart Agent service Initialized on all database environment machines.

    Terminal input
    systemctl start pgsmart-agent

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

      Terminal input
      su - PgSmart

  • PgSmart Agents Registration through the PgSmart-Client.

Command Syntax

To install the backup service, use one of the following commands:

Terminal input
    pgsmart install -s backup [Flags]
Terminal input
    pgsmart install --service=backup [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 service installation. Used in conjunction 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 -a <value> -q --service=backup
Figure 1 -Backup Installation - Non Interactive
Figure 1 -Backup Installation - Non Interactive
Interactive Installation
Terminal input
pgsmart install

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

  2. Select Backup Management Service.

  3. Select the Major version of ambient PostgreSQL.

  4. Select the release of the ambient PostgreSQL majority version.

  5. Confirm installation.

  6. Confirm whether you want to download and install the PostgreSYS package 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.

    Figure 2 -Backup Installation - Interative
    Figure 2 -Backup Installation - Interative

Command Variations for Interactive Installation​

Some parameters can be passed up front in the command; however, the execution is still interactive. This means that during the installation, the parameters provided must be confirmed, along with the 'default' values for those parameters that are not known.

Terminal input
    pgsmart install --service=backup
Terminal input
    pgsmart install  --pgversion=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