Skip to main content

What is PostgreSYS?

What is PostgreSYS? icon

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.

Figure 1 - Architectural model proposed by PostgreSYS
Figure 1 - Architectural model proposed by PostgreSYS

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.

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 Architecture​

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;

  • Integration: represented by the PgSmart component, it provides integration, automation, and orchestration of platform components, along with highly intuitive interfaces for database analysts and administrators.

          

Documentation 3.1.1-2