EnterpriseDB launches open source TPA for high availability Postgres clusters

EnterpriseDB’s Trusted Postgres Architect (TPA) is now available as an open source tool that can be used by any PostgreSQL user. By simplifying the process of setting up High Availability (HA) Postgres clustersThis deployment automation and configuration management solution would help businesses quickly and error-free create reliable, production-ready clusters.

The process of deploying and managing high availability (HA) clusters is complex and involves making choices that significantly influence operational resilience, data accuracy, and performance. Additionally, not all companies have the internal knowledge to manage these complications.

With this launch, TPA offers businesses access to EDBindustry knowledge at every stage of a cluster’s lifespan, from choosing the best configuration to maintaining it. Additionally, TPA manages the configuration, maintenance and monitoring of EDB’s high availability solutions as well as open source community tools. This would provide a “simple, reliable, and consistent” method of managing clusters, which would benefit the Postgres community as a whole.

Jozef de Vries, director of product engineering at EDB, said: “TPA not only embodies EDB’s commitment to customer success, but also reflects our ongoing commitment to supporting the broader Postgres community. It’s clear that establishing strong production database clusters is crucial for anyone managing mission-critical applications. This method saves time and reduces the chance of errors, giving consumers and open source users peace of mind.

Postgres experts at EDB

Users can expect the following benefits by using TPA:

• Easy-to-use structure, optimal performance – Playing with different cluster designs and components is made possible by the ease of use of the framework. Users can develop and maintain HA infrastructures, ensure optimal performance and reliability, and reduce downtime with a few simple instructions.
• Selection of proven and reliable architecture – EDB’s Postgres specialists create and evaluate designs that include high-availability replication, disaster recovery backups, and replication error protection. TPA’s simple and succinct vocabulary makes it easy for the user to experiment with these underlying designs.
• Virtually zero downtime – TPA reduces downtime by updating software configurations and making adjustments. Additionally, near-zero downtime can be achieved in combination with EDB Postgres Distributed’s Always On architecture for active-active use cases.
• Supported by a Postgres developer – EDB, one of the main contributors to Postgres, would offer great insights enabling customers to make wise choices at every step, from choosing an architecture to maintaining high availability.

The need for fast recovery times and continuous operation of databases would be growing, and this can be achieved by distributing databases across clusters. However, setting up and managing a multicluster database can be difficult. With the introduction of TPA, EDB has taken a big step forward in providing the Postgres community with a simple solution to this problem. With the help of this technology, businesses would be able to confidently create and maintain robust database clusters, which would help improve operational resilience and reduce errors.

According to Carol Olofson, vice president of research at IDC“This initiative not only demonstrates EDB’s commitment to enterprise customer success, but also reinforces the company’s ongoing efforts to drive innovation within the Postgres ecosystem.”

With the highest concentration of Postgres engineers and technologists in the world, EDB has long been a major contributor to the open source community. This release would represent the company’s most recent step in this regard. Before that, EDB made significant contributions to PostgreSQL 15 and created CloudNativePG, the first open source operator suitable for Kubernetes. Later this month, EDB will make an announcement on new contributions to PostgreSQL 16, demonstrating its continued commitment to advancing open source solutions.