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…
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
Variants
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
- Immich postgres help : r/selfhosted - Reddit (reddit)
- Immich App Fails Postgres 18 Update - forums.truenas.com (forum)
- Immich docker, and Postgresql14 going? : r/unRAID - Reddit (reddit)
Collected 49 days ago - public community threads