High Availability Service Installation via PgSmart Web

The PostgreSQL ecosystem components that PgSmart integrates with to provide the high availability service are: Patroni, etcd, and HAProxy.

Prerequisites

• PgSmart Web Installation, following the minimum requirements.

• Additional package repository to resolve indirect dependencies. In accordance with each organization's security and support policies, Tecnisys does not provide these packages. For Enterprise Linux family distributions, the Extra Packages for Enterprise Linux - EPEL repository usually provides the required indirect dependencies.

• The PgSmart Agent must be installed and running on the machine where the service will be installed.

• PgSmart Agent Registration in PgSmart Web.

warning

We recommend using dedicated servers for each high availability component.

warning

The high availability agent, represented by the Patroni component, must be installed on the same server as the Database Service, represented by the PostgreSQL component.

Instructions

1. Go to Início/Gerenciar Ambientes/Serviços. All installed services in all environments will be displayed.
2. Click Instalar.
3. Select the Environment where the service will be installed.
4. Select the High Availability service.
5. Select the Base Version of PostgreSQL [e.g., 16].
6. Select the PostgreSQL Version [e.g., 16-2].
7. Click Avançar.
8. Select the IP address of one or more members of the Distributed Configuration Store (DCS).
9. Select the IP address of one or more PgSmart Agents.
10. Select the IP address of one or more High Availability Proxy nodes.
11. Click Instalar.

Figure 1 - High Availability Service Installation - Service Identification

Figure 2 - High Availability Service Installation - Agent Identification

Figure 3 - High Availability Service Installation - Confirmation

Video