Immich Postgres

Pre-built PostgreSQL 14 database for the Immich self-hosted photo library, bundled with the VectorChord vector search extension that Immich requires to store…

  • Network Services
  • Other
  • Productivity
  • Tools & Utilities
Pre-built PostgreSQL 14 database for the Immich self-hosted photo library, bundled with the VectorChord vector search extension that Immich requires to store and search media metadata. It is the "db" service from Immich's official Docker Compose stack and runs alongside the Immich server and Redis on a shared custom Docker network.

Platform availability

Available on 1 of 10 platforms

  • Unraid
  • TrueNAS (not listed)
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm (not listed)
  • Mac (not listed)
  • Windows (not listed)
  • Linux (not listed)
  • Any server (not listed)

Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.

70/100 Good

Maintained
100last commit 7 days ago
Popular
8722,822 GitHub stars
Easy to install
351 install platform, install notes, Docker image
Light to run
106 GB minimum RAM

Availability: platform listings confirmed today, links checked 21 days ago

GitHub stars
22,822
Open issues
0
Last commit
2026-11-14
Activity
rising

Checked 7 days ago - source: GitHub (postgres/postgres)

Resources & Compatibility

Minimum requirements: 6 GB RAM, 2 CPU core(s).

Checked 54 days ago - source: Docker Hub image tags and published docs

First-install notes

  • Set your Immich URL and API key Edit config.yaml and fill in immich_url (where Immich is running) and immich_api_key (a secret code that lets the frame connect to it). Without these required settings, the kiosk cannot load photos from your Immich instance. source
  • Prepare folders before starting Docker Create the ./immich-kiosk and ./config folders and download the example config.yaml before running docker compose up -d. That command starts the app in the background, and it needs your config file to know how to work. source
  • Tell the kiosk which photos to show Add at least one photo source in config.yaml, such as albums, people, tags, or dates. Leaving placeholder IDs or no source may prevent the frame from showing the photos you want. source
  • Shared Docker network Place the container on the same custom Docker network as the Immich server (usually named "immich") so the server can reach it by the container name "immich-postgres". source
  • Credentials and initialization Set POSTGRES_PASSWORD to exactly match the DB_PASSWORD in the Immich server container. Changing the username, database name, or password after first start has no effect because the data directory is already initialized. source

Fetched 47 days ago - each note links to its source

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

Can I run Immich with a pre-existing Postgres server instead of the bundled Immich Postgres service?

It is possible, though not officially recommended. You should have a basic understanding of Postgres and the Linux command line, otherwise the default setup is recommended.

What symptoms indicate that the Immich Postgres container is not starting?

Immich may fail to start with a log message saying it can’t find the database. The Postgres container may show no activity and not bring up logs.

What workaround is reported when Immich fails after a Postgres 18 update?

A reported workaround is clearing the Postgres data dataset and rebuilding the database.

Which database credentials should I use when starting over with Immich and PostgreSQL 14 in Docker?

Use the template’s DB user and password for the database connection.

Answers sourced from docs.immich.app, forums.truenas.com, www.reddit.com, www.reddit.com

Community

Collected 49 days ago - public community threads