# PostgreSQL HA

PostgreSQL HA is a self-hosted databases app. High-availability PostgreSQL cluster deployed via Helm, providing automatic primary-to-standby replication and failover for databases that require continuous uptime. It is open source and self-hosted, installable on Docker Hub and Kubernetes (Helm).

Canonical page: https://ourlocalhost.com/app/4680/postgresql-ha

## Description

High-availability PostgreSQL cluster deployed via Helm, providing automatic primary-to-standby replication and failover for databases that require continuous uptime.

## Platform availability

Available on 1 of 10 platforms: Helm.

## Links

- Docker Hub: https://hub.docker.com/r/bitnamicharts/postgresql-ha
- Kubernetes (Helm): https://artifacthub.io/packages/helm/bitnami/postgresql-ha

## Common questions

### Does the single-datacenter HA design include a proxy for client connections?

The shared 3-node design uses HAProxy and Keepalived along with repmgr and Terraform. It also includes runbooks for setup, operations, failover, and troubleshooting.

### Can a standby node take over if the primary PostgreSQL server fails?

PostgreSQL high availability is designed so a second server can take over quickly if the primary server fails. It can also allow several computers to serve the same data for load balancing.

### Can the HA setup support point-in-time recovery?

A self-hosted HA guide uses WAL-G for point-in-time recovery together with pg_auto_failover and role-aware DNS. This shows PITR can be part of the described PostgreSQL HA setup.

### Can redundant PostgreSQL be hosted across multiple locations or providers?

One self-hosted setup runs PostgreSQL on three servers across three locations and three providers. It uses a large dedicated server plus smaller servers for redundancy.

## Alternatives

- Apache Cassandra
- CockroachDB: CockroachDB is a distributed SQL database for developers and operators of transactional applications that need horizontal scaling and resil…
- CouchDB: CouchDB is a document-oriented NoSQL database with a RESTful HTTP/JSON interface for storing, querying, and synchronising JSON documents ac…
- FerretDB: FerretDB is an open-source MongoDB compatibility proxy for self-hosted stacks.
- Firebird: Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms.
- Microsoft SQL Server: SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from st…
- MindsDB: MindsDB is an AI data solution that enables humans, AI, agents, and applications to query data in natural language and SQL, and get highly…
- MongoDB: MongoDB is an open-source, document-oriented NoSQL database that stores flexible, JSON-like documents, helping developers and self-hosters…
- MySQL Community Edition: Free GPL database platform supporting SQL and NoSQL applications with InnoDB storage, replication, clustering, connectors, and cross-platfo…
- SQLite: SQLite is a lightweight, embedded relational database engine that stores an entire database in a single file on your device.
- SurrealDB: SurrealDB is a modern "all-in-one" database that stores and organises your app's information.
- mariadb: MariaDB is a fast, open-source relational database server forked from MySQL by its original developers.

---
Source: Our Local Host (https://ourlocalhost.com/app/4680/postgresql-ha), the self-hosted and open-source app directory.
