PostgreSYS Component Configuration via PgSmart Web
See below the available commands to configure PostgreSYS components via PgSmart Web:
PgSmart Web Configuration
Database Configuration
General Settings
Define where PostgreSQL will find its execution files and where to store the 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.