Concepts

The PostgreSYS Platform, built entirely on open-source software, comprises a range of essential components, each specializing in a critical aspect or function of a database environment. The following topics outline key concepts to help understand these components.

Integration

PgSmart

PgSmart is the integration tool of the PostgreSYS Platform. Through its Command-Line Interface (CLI) and Web Interface (available from version 4.0.0) , it provides commands to install, configure, and manage PostgreSYS components in a simple and intuitive manner, streamlining operational tasks.

Database

PostgreSQL

PostgreSQL, the main component of PostgreSYS, is an open-source DBMS widely recognized for its robustness and versatility.

Spatial Data

PostGIS is the spatial extension of PostgreSYS, which enhances PostgreSQL by supporting storage, indexing, and querying of spatial data.

Disaster Recovery

pgBackRest

pgBackRest is the advanced Backup and Recovery tool for PostgreSYS environments.

High Availability

Patroni

Patroni is the PostgreSYS Platform's High Availability Agent. It plays a crucial role in ensuring database service continuity. It is one of the most popular high availability managers in the PostgreSQL community and provides features to automate and orchestrate PostgreSQL database clusters.

etcd

etcd, the Distributed Configuration Store (DCS) in PostgreSYS, enables HA agents to share configuration and state information reliably and consistently, which is crucial to maintaining the integrity and availability of instances.

HAProxy

HAProxy, the High Availability Proxy service in PostgreSYS, acts as an intermediary between client applications and the database, detecting and routing connections to the primary instance based on server health and load.

Connection Pool

PgBouncer acts as an intermediary between client applications and the PostgreSQL server, handling authentication and efficient connection pooling. The authentication process ensures that only authorized clients have access to the instance's databases.

Observability

Prometheus

Prometheus is PostgreSYS's tool for monitoring and observability — a complete system for monitoring and trend analysis that includes active scraping, storage, querying, graphing, and alerting based on time series.

Grafana

Grafana is the data visualization component of PostgreSYS. Highly versatile and open source, it is designed to query various data sources and enable visualization and manipulation of information. It allows the creation of personalized, interactive dashboards.