PostgreSQL

Open-source relational database with JSON support, full-text search, and extensions.

database storage utility self-hosted homelab docker sql orm

Ports

Notes

Use Cases

Official Website View on GitHub

About

What PostgreSQL does

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 co...

Install Flow

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, deployment notes, and where to find the original compose template.

After deployment, Yantr lets you publish additional ports from the stack page using Docker-style syntax. Use 8080:8080 for a fixed host port or just 8080 to let Docker assign a random port.

Use Cases

What people run it for

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.

Technical Details

Ports, image, and service metadata

Ports

Port	Protocol	Label
5432	TCP	Database

Docker Image

postgres:latest

Service Name

postgresql