# PostgreSQL 16

PostgreSQL 16 is an open-source object-relational database system for storing structured data and powering applications that require reliable, transactional SQL storage. It is open source and self-hosted, installable on Docker Hub, TrueNAS and Unraid.

Canonical page: https://ourlocalhost.com/app/4014/postgresql-16

## Description

PostgreSQL 16 is an open-source object-relational database system for storing structured data and powering applications that require reliable, transactional SQL storage. It supports standard SQL queries, JSONB documents, and ACID compliance, making it suitable for self-hosted service backends.

## Platform availability

Available on 2 of 6 install platforms: Unraid, TrueNAS.

## Health score

64/100 (Good), based on 3 of 4 factors.
- Maintained: 88 (last commit 10 days ago)
- Popular: 68 (2,519 GitHub stars)
- Easy to install: 10 (1 install platform)

## Links

- Docker Hub: https://hub.docker.com/_/postgres
- TrueNAS: https://apps.truenas.com/catalog/postgres
- Unraid: https://ca.unraid.net/apps/postgresql16-1fjhyx31tjdck3?q=postgresql16
- Official website: https://www.postgresql.org/
- GitHub: https://github.com/docker-library/postgres

## Common questions

### Where should I look for authoritative details about the official PostgreSQL Docker image?

Docker Hub has the full readme, and the official-images repository's library/postgres file is the current source of truth.

### What redundancy approach is described for hosting PostgreSQL for hobby projects?

The post describes three servers across three locations and providers, with one large dedicated server and two small servers used to make critical services such as PostgreSQL redundant.

### Why should PostgreSQL log file handling be configured?

Logging helps for auditing purposes and to diagnose problems.

### What tradeoff is mentioned for self-installing PostgreSQL instead of using a hosted service?

Self-installing PostgreSQL is lower cost and provides a learning benefit, but it carries ongoing time costs.

### Should a beta PostgreSQL release be deployed in production while testing an update?

The official site advises against running beta versions in production, while encouraging testing typical application workloads against them to help find bugs.

## Alternatives

- 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…
- MongoDB: [h3]MongoDB[/h3]MongoDB (from "humongous") is a cross-platform document-oriented database.
- 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 compact, built-in filing system for your data.
- SurrealDB: SurrealDB is a modern "all-in-one" database that stores and organises your app's information.

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