PostgreSYS Component Configuration via PgSmart Web

See below the available commands to configure PostgreSYS components via PgSmart Web:

PgSmart Web Configuration

PgSmart Web Parameter Configuration

Configure the parameters of PgSmart Web.

PgSmart Web Agent Registration

Register PgSmart Web agents.

PgSmart Web Settings

View, add, edit, or remove a PgSmart Web agent.

Database Configuration

General Settings

Define where PostgreSQL will find its execution files and where to store the instance data.

PostgreSQL Binary Directories

Definition and organization of binary directories.

Instance Data Directory

Location and management of instance data.

Database Instance Configuration

Manage access rules and parameters of the database instance.

Access Rules

Configure access rules that restrict data access by connection type, database name(s), user(s) or group(s), authorized subnet/host, and authentication method.

Database Instance Service Parameters

Adjust instance configuration to optimize performance by editing the `postgresql.conf` file in the cluster directory.

Backup Policy Configuration

Backup Sites

Define the base data directory where the PostgreSQL cluster is stored. This directory is essential for backups.

Backup Routines

Create routines in the system's crontab (Linux).

Backup Repositories

Define the location for storing backup metadata, actual backups, and transaction logs.

Backup Parameters

Configure global backup parameters.

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

Specify the users authorized to connect via the connection pool.

PostgreSQL and PgBouncer Exporter Configuration

Connection User Configuration for Metrics Collection

View and edit the connection user password for metrics collection.

PostgreSQL Metrics Exporter

Configure the collection and exposure of database metrics such as transactions, query latency, memory usage, and statistics.

PgBouncer Metrics Exporter

Configure the collection and exposure of PgBouncer metrics such as active connections, waiting queue, and resource usage.