PostgreSQL HA
High-availability PostgreSQL cluster deployed via Helm, providing automatic primary-to-standby replication and failover for databases that require continuous…
Platform availability
Available on 1 of 10 platforms
- Unraid (not listed)
- TrueNAS (not listed)
- Umbrel (not listed)
- ZimaOS (not listed)
- Proxmox (not listed)
- Helm
- Mac (not listed)
- Windows (not listed)
- Linux (not listed)
- Any server (not listed)
Health score
Not enough data yet for a health score. It needs at least 2 of 4 factors: maintenance, popularity, ease of install, resource needs.
Availability: platform listings confirmed today
No GitHub repository data collected yet.
Resources & Compatibility
Requirements not published yet.
First-install notes
- Set up the data directory before starting Create a folder for PostgreSQL’s data and make the postgres user (the account the database runs as) own it; wrong ownership can stop the server from starting. source
- Start it automatically when the box boots Add a startup command so PostgreSQL begins after a reboot; without it, anything waiting for the database will not work until you start it by hand. source
- Match database tables on both servers If you are setting up replication, create the same tables on the publisher (source database) and subscriber (copy); mismatched tables can make replication fail or data go missing. source
Fetched 44 days ago - each note links to its source
Variants
Alternatives (12)
- 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.
Checked 40 days ago - source: AlternativeTo
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.
Answers sourced from forum.mattermost.com, temps.sh, www.postgresql.org, www.redditmedia.com
Community
- Do you need a HA, Self-hosted Postgres DB Cluster? (forum)
- Postgresql setup for HA - Atlassian Community (other)
Collected 48 days ago - public community threads