Skip to main content
Version Next

High Availability DCS Configuration

Below are the necessary commands to configure high availability in the PostgreSQL Ecosystem:

Prerequisites
note

In a high availability environment, it is recommended to use dedicated servers exclusively for each component.

Command Syntax
Terminal input
    pgsmart ha dcs config [Flags]

Flags:​

  • -h, --help => Help
Non-Interactive Configuration

Non-interactive execution is disabled for this operation.

Interactive Configuration
  1. Select the PgSmart Agent (or Register new Agent).
note

If a Distributed Configuration Store (DCS) configuration file already exists, two options will be presented:

  • Adicionar Membro ao Cluster: Allows adding a member to the cluster.
  • Editar Configurações Existentes: Allows editing existing configurations.

If the option to Add a new member to the cluster is selected:​

2.1. Enter the name of the new server.

2.2. Enter the IP address of the new server for internal DCS communication.

2.3. Enter the port of the new server for internal communication.

2.4. Confirm the addition of the member to the DCS.

Figure 1 - High Availability - DCS - Add member.
Figure 1 - High Availability - DCS - Add member.

If no configuration file exists in the repository or if "Editar Configurações Existentes" is selected:​

note

Editing existing configurations will overwrite the current file in the Distributed Configuration Store.

3.1. Enter the High Availability Environment name. [Default: pgsys-producao]

3.2. Identify the server. [Default: current server]

3.3. Specify the network interface to be used internally by the Distributed Configuration Store servers.

3.4. Specify the port to be used internally by the Distributed Configuration Store servers. [Default: 2380]

3.5. Specify the network interface to be used for client requests to the Distributed Configuration Store.

3.6. Specify the port to be used for client requests to the Distributed Configuration Store (DCS).

3.7. Confirm if the Distributed Configuration Store already exists on other servers (if yes, inform for each: server name, IP address for internal communication, and port).

3.8. Confirm saving the DCS configuration.

3.9. Confirm service initialization (restart).

Figure 2 - Alta Disponibilidade - DCS - edita
Figure 2 - Alta Disponibilidade - DCS - edita
note

If a DCS is already configured, PgSmart will request confirmation to replace the existing configurations with the new parameters.