# PostgreSQL

PostgreSQL is an open source object-relational database known for reliability and data integrity. It is open source and self-hosted, installable on Docker Hub, TrueNAS, ZimaOS, Proxmox and Kubernetes (Helm).

Canonical page: https://ourlocalhost.com/app/4583/postgresql

## Description

PostgreSQL (Postgres) is an open source object-relational database known for reliability and data integrity. ACID-compliant, it supports foreign keys, joins, views, triggers and stored procedures.

## Platform availability

Available on 4 of 10 platforms: TrueNAS, ZimaOS, Proxmox, Helm.

## Health score

81/100 (Excellent), based on 3 of 4 factors.
- Maintained: 100 (last commit 17 days ago)
- Popular: 87 (22,705 GitHub stars)
- Easy to install: 35 (2 install platforms, install notes)

## Links

- GitHub: https://github.com/postgres/postgres
- Docker Hub: https://hub.docker.com/r/islandora/postgresql
- TrueNAS: https://apps.truenas.com/catalog/postgres
- ZimaOS: https://github.com/IceWhaleTech/CasaOS-AppStore/tree/main/Apps/PostgreSQL
- Proxmox: https://community-scripts.github.io/ProxmoxVE/scripts?id=postgresql
- Kubernetes (Helm): https://artifacthub.io/packages/helm/bitnami/postgresql
- Official website: https://www.postgresql.org/

## Common questions

### What responsibilities do you take on when self-hosting PostgreSQL?

You become fully accountable for backups, downtime, and patching. You should also verify that you can actually restore from your backups.

### How can hobby projects make self-hosted PostgreSQL more redundant?

One setup uses a large dedicated server plus two smaller servers to keep PostgreSQL and other critical services redundant.

### Should PostgreSQL beta releases be used in production?

The official PostgreSQL site advises against running beta versions in production, though it encourages testing typical application workloads against them.

### When does PostgreSQL 14 stop receiving fixes?

PostgreSQL 14 will stop receiving fixes on November 12, 2026.

### Can PostgreSQL deployment fail during installation?

Yes, a user reported that PostgreSQL deployment failed because the installation did not complete successfully.

## 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/4583/postgresql), the self-hosted and open-source app directory.
