Skip to main content

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.

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.

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, which, through the Command Line Interface (CLI) or Graphical Interface (Web), sends requests to the agents.

Communication between client and agent occurs via REST API, using JSON as the protocol and SSL/TLS to ensure security.

In a typical scenario, you install a PgSmart Agent 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.

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.

Why use PostgreSYS?​

  • Integration: PostgreSYS ensures the integration and operation of the main components of the PostgreSQL Ecosystem. See the Version Matrix for more information;

  • Ease: Through a single repository, it is possible to install the entire platform, including extensions and dependencies;

  • Agility: PgSmart provides a fast and intuitive experience, with interactive menus, smart searches, best practices suggestions, action logs, export and import of templates, and many other features;

  • Efficiency: PostgreSYS is designed to meet the needs of modern database environments, with connection pools for connection reuse, reducing computational cost and increasing performance;

  • Resilience: In PostgreSYS, it is possible to create comprehensive Backup Policies, adapted to your Organization's needs and infrastructure limitations.

  • Availability: PostgreSYS enables the creation of high availability environments for PostgreSQL instances, with automatic failover, replica provisioning, and connection proxy;

  • Flexibility: PostgreSYS is highly flexible and extensible, allowing the administrator to choose which components to install and configure. As well as register existing installations, as long as they are supported;

  • National Innovation: We are proud to say that PostgreSYS is a Brazilian solution, developed by a team of software engineers and specialists attentive to the needs of modern database environments in Brazil and around the world.