24 October 2024

A modern, open-source alternative to cloud-managed databases (

 

Deploy HA Postgres on: Bare Metal

High-Availability Cluster for PostgreSQL®

A modern, open-source alternative to cloud-managed databases.


HOW IT WORKS
Open Source Relational Database

PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. More and more companies around the world are choosing it for their new products, or migrating from other database systems to PostgreSQL. It has been ranked as the DBMS of the Year multiple times, and its popularity continues to grow, as illustrated by the DB-Engines ranking trend:



PostgreSQL is used by 52% of professional developers and is the most popular database for the second year in a row. Source: Stack Overflow - Most popular technologies.

PostgreSQL is an outstanding database, but unlike commercial solutions, it lacks built-in tools for high availability (auto-failover), monitoring dashboards, and a graphical management console. While this may seem like a limitation, the open-source ecosystem offers flexible solutions to meet these needs. However, integrating these tools into a robust enterprise cluster requires significant PostgreSQL expertise to ensure a reliable, production-ready solution.

To bridge this gap, the postgresql_cluster automation toolkit was developed in 2019 for personal use, and later shared with the community. It handles the deployment of high-availability clusters (using Patroni) and addresses management tasks such as minor and major upgrades, backup configuration with support for automated restore a database to a point in time (PITR), and cluster scaling with horizontal read load distribution across replicas, among many other features. The project has been around for over 5 years and is used by companies worldwide. It continues to actively evolve and improve, leveraging the practical experience of PostgreSQL experts (DBA) who use our product to manage database clusters in production environments for mission-critical, high-load databases.

This is not a fork; it is 100% PostgreSQL. It is not a cloud service (SaaS/DBaaS) that requires additional fees. It is a 100% free solution, available for commercial use under the MIT license.

The project is solely funded by sponsors who choose to support it voluntarily or to gain access to personalized support.

No comments: