PostgreSQL

Advanced open-source relational database with JSON support, full-text search, and powerful extensions.

database storage utility self-hosted homelab docker sql orm

Official Website View on GitHub

About

PostgreSQL is a powerful, open-source object-relational database system known for reliability, feature robustness, and performance. It supports both SQL (relational) and JSON (non-relational) querying, making it perfect for modern applications. Features include ACID compliance, MVCC for concurrent access, foreign keys, triggers, stored procedures, views, complex queries, JSONB for document storage, full-text search, GIS extensions (PostGIS), and an extensive ecosystem of extensions (pgvector for AI, timescaledb for time-series, citus for distributed). It's the database of choice for many production applications.

How to Self-Host PostgreSQL

PostgreSQL can be deployed with standard Docker Compose using the Yantr app catalog. This page collects the basic information searchers usually need first: what PostgreSQL does, which Docker image Yantr uses, default ports, dependencies, and where to find the original compose template.

If you searched for PostgreSQL Docker, PostgreSQL Docker Compose, or self-host PostgreSQL, this page is the direct landing page for that app in Yantr's catalog.

Use Cases

Use as the database backend for complex applications like Wiki.js, Ghostfolio, or Home Assistant.
Store JSON data alongside relational data in the same database.
Enable full-text search for building search features in your applications.
Use pgvector extension for storing and querying AI embeddings.