Overview
Start here to better understand PostgreSYS and the PostgreSQL Ecosystem. In this section, we explain the challenges the platform aims to solve and the advantages it offers for your database infrastructure.
What is PostgreSYS?
PostgreSYS is the database environment administration platform developed by Tecnisys, designed to simplify the deployment, configuration, monitoring, and management of PostgreSQL ecosystem components.
Throughout its journey as a company specialized in PostgreSQL support, Tecnisys identified a common challenge among its clients: the complexity in selecting and maintaining the appropriate PostgreSQL ecosystem components for their environments.
The PostgreSQL ecosystem comprises hundreds of components, developed and maintained by the open-source community. Issues such as support, security, installation, evolution, and integration are constant challenges in the daily routine of database administrators.
With this in mind, we developed PostgreSYS, a platform that integrates the most relevant components of the PostgreSQL ecosystem for productive database environments. All components are thoroughly tested to meet the technical requirements of performance, security, and availability for mission-critical systems.
To manage the platform, we created PgSmart, which allows for installing, configuring, managing, and monitoring all components of the PostgreSQL environment in a simple and flexible way.
PostgreSYS Platform Architecture
PgSmart allows centralized management of all platform services. Its Client/Server architecture consists of the PgSmart Agent, installed on machines or servers, responsible for executing installation, configuration, management, and monitoring operations of the services, and the PgSmart Client (CLI) and PgSmart Web (Graphical Interface), which send requests to the agents.
Communication between client and agent occurs via a REST API, using JSON as the protocol and SSL to ensure security.
In a typical scenario, a PgSmart Agent is installed on each machine or server that hosts the services to be managed. The CLI or Web interface is installed on a separate machine, from which it is possible to remotely manage all agents, performing installation, configuration, and monitoring tasks for the services on each server.
Why use PostgreSYS?
-
The PostgreSYS Platform offers stability, performance, and practicality by integrating essential services and tools for the PostgreSQL ecosystem.
-
It provides, through a single repository, an easy and secure way to install PostgreSQL and its components.
-
Its orchestration tool, PgSmart, delivers a fast and intuitive experience, offering interactive menus, smart searches, best practices suggestions, action logs, export/import of PostgreSQL initialization templates, and many other features.
-
PostgreSYS includes comprehensive backup and restore capabilities, adaptable to large PostgreSQL environments. Through PgSmart, users can schedule or manually run full, incremental, and differential backups. Incremental and differential backups notably reduce execution time. Additionally, the delta restore option speeds up restoration by comparing checksums for secure file recovery.
-
PostgreSYS simplifies the high availability (HA) setup for PostgreSQL, offering asynchronous replication by default and optional synchronous replication, according to your environment's needs.
-
The platform supports connection pooling, enabling efficient reuse and scaling of PostgreSQL connections transparently, via PgBouncer.
-
PostgreSYS is flexible and extensible, adapting to the demands of production environments.
-
Each new release is subject to strict quality control, ensuring stability, component updates, and seamless integration.
-
PostgreSYS is a Brazilian Data Platform in continuous evolution, developed by software engineers and specialists focused on addressing national organizational needs.
PostgreSYS Services
The main services that make up the PostgreSYS platform architecture are:
-
Database: represented by the PostgreSQL component, the world’s most advanced open-source Object-Relational Database Management System. It is present in systems across various industries worldwide, with over 30 years of continuous development and evolution;
-
Connection Pool: represented by the PgBouncer component, it reduces the computational cost of opening new connections to PostgreSQL instances;
-
Backup Management: represented by the pgBackRest component, it enables configuration of full, differential, and incremental backups, delta, compression, and fast recovery;
-
High Availability: represented by the Patroni component, it provides automatic failover, replica provisioning from templates or existing instances, leader election rules, and state monitoring;
-
Observability: represented by the Prometheus, Grafana, Alertmanager, and Karma components, it allows a comprehensive and detailed view of the PostgreSQL environment, facilitating issue identification, failure diagnosis, and performance optimization;