# Immich Postgres

Immich Postgres is a self-hosted network services app. 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 open source and self-hosted, installable on Unraid.

Canonical page: https://ourlocalhost.com/app/2924/immich-postgres

## Description

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.

## Health score

70/100 (Good), based on 4 of 4 factors.
- Maintained: 100 (last commit 7 days ago)
- Popular: 87 (22,822 GitHub stars)
- Easy to install: 35 (1 install platform, install notes, Docker image)
- Light to run: 10 (6 GB minimum RAM)

## Links

- GitHub: https://github.com/postgres/postgres
- Official website: https://www.postgresql.org/
- Unraid: https://ca.unraid.net/apps/immich-postgres-1ge6blh1b6dis1?q=immich-postgres
- Documentation: https://www.postgresql.org/docs/

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

## Alternatives

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

---
Source: Our Local Host (https://ourlocalhost.com/app/2924/immich-postgres), the self-hosted and open-source app directory.
