PostgreSYS Service Configuration

Review the procedures for configuring PostgreSYS services:

PgSmart CLI Configuration

Configure PgSmart CLI parameters. Add and register new Agents or edit and remove registered Agents.

PgSmart CLI Parameter Configuration

Configure PgSmart CLI parameters.

PgSmart CLI Agent Registration

Register PgSmart CLI Agents.

PgSmart CLI Agents

View, add, edit, or remove a PgSmart CLI Agent.

Metadata database connection Configuration

View and edit Connection user password and port where the PostgreSYS Environment metadata database will receive connections .

Audit and Traceability

Understand the log structure, command traceability configuration, and Agent detail levels.

Database Configuration

Define the absolute path of the installation directory for a specific PostgreSQL version.

General Configuration

Define where PostgreSQL will find its executable files and where it will store instance data.

PostgreSQL Binary Directory

Set the installation directory location for a specific PostgreSQL version.

Instance Data Directory

Set the location of the directory where the database stores its configuration and data files.

Database Instance Configuration

Manage access rules and instance parameters.

Access Rules

Configure access rules to restrict data access based on connection type, database name(s), user(s) or group(s) ID, authorized subnet or host, and authentication method.

Database Instance Parameters

Tune instance settings to optimize performance by editing the postgresql.conf file in the database directory.

Backup Policy Configuration

Define the data directory location. Configure backup routines. Set the storage location for metadata, backups, and transaction logs. Enable WAL archiving.

Backup Sites

Specify the base directory where PostgreSQL stores its database files. This directory is essential for performing backups.

Backup Routines

Create scheduled routines using the system's crontab (Linux).

Backup Repositories

Define where metadata, backup files, and transaction logs will be stored.

WAL Archiving

Enable archiving of transaction logs (WAL - Write-Ahead Logging).

Backup Parameters Configuration

Configure the Backup Parameters.

Global Backup Parameters

Configure the Global Backup Parameters.

Backup Site Parameters

Configure the Parameters for a Backup Site.

Backup Repository Parameters

Set the parameters for backup repository configuration.

High Availability Components Configuration

Distributed Configuration Store - DCS

Configure the DCS – storage and replication component for cluster configuration and state information.

High Availability Agent

Configure the local PostgreSQL monitoring component.

High Availability Proxy

Configure the connection routing component to the primary (master) node.

Connection Pool Configuration

Connection Pools

Configure one or more connection pools.

Authorized Users

Identify which users are authorized to connect through the pool.

Global Connection Pool Parameters Configuration

Configure the Global Parameters of the Connection Pool Service.

Observability Configuration

Connection User Configuration for Metrics Collection

View and Edit the connection user's password for metrics collection.

Exporters Configuration

Configure Exporters to collect metrics from a wide variety of systems and services.

Node Exporter

Configure operational metrics of physical or virtual machines.

PostgreSQL Exporter

Configure metrics on transactions, query latency, memory usage, database usage statistics, and more.

PgBouncer Exporter

Configure PgBouncer statistics.

pgBackRest Exporter

Configure metrics related to backup and restore processes.

Metric Collector

Configure the Collector (Prometheus) to collect data from various Exporters.