# PostgreSQL Immich

PostgreSQL Immich is a pre-configured PostgreSQL 16 container with the pgvecto.rs vector search extension, built as a drop-in database for the Immich self-hosted photo and video manager. It is open source and self-hosted, installable on TrueNAS, Proxmox, Docker Hub and Unraid.

Canonical page: https://ourlocalhost.com/app/453/postgresql-immich

## Description

PostgreSQL Immich is a pre-configured PostgreSQL 16 container with the pgvecto.rs vector search extension, built as a drop-in database for the Immich self-hosted photo and video manager. It eliminates manual extension setup and version matching, giving Immich a ready-to-use backend for AI-powered vector similarity search. It is intended for homelab users deploying Immich who want a compatible database without hand-configuring Postgres.

## Platform availability

Available on 3 of 9 platforms: Unraid, TrueNAS, Proxmox.

## Health score

75/100 (Good), based on 4 of 4 factors.
- Maintained: 100 (last commit 6 days ago)
- Popular: 100 (116,397 GitHub stars)
- Easy to install: 35 (1 install platform, install notes, Docker image)
- Light to run: 20 (6 GB minimum RAM, runs on ARM)

## Links

- TrueNAS: https://apps.truenas.com/catalog/immich
- Proxmox: https://community-scripts.github.io/ProxmoxVE/scripts?id=immich
- Docker Hub: https://hub.docker.com/r/tensorchord/pgvecto-rs
- Unraid: https://ca.unraid.net/apps/postgresql-immich-0nxdbe40twm560?q=PostgreSQL_Immich
- Official website: https://www.postgresql.org/

## Common questions

### Can I store the Immich PostgreSQL data in a bind mount instead of a named Docker volume?

A user sought help changing the Immich PostgreSQL storage location from a named Docker volume to a bind-mounted folder because the bind mount configuration produced errors.

### What can cause my Immich PostgreSQL database to become inaccessible after an update?

A user reported problems accessing an existing Immich PostgreSQL 14 database after updates and periods without login. They were asking for help restoring access.

### What happens if PostgreSQL is not configured to start automatically after a reboot?

The database server can remain stopped after the host restarts. In that case, Immich cannot reach its database.

### What should I check when Immich does not start?

Check for Docker startup errors and whether the container runs out of memory. The source walks through specific startup errors, their causes, and fixes.

## Alternatives

- Apache Cassandra
- CockroachDB: CockroachDB is a distributed SQL database for developers and operators of transactional applications that need horizontal scaling and resil…
- CouchDB: Apache CouchDB is a distributed, fault-tolerant and schema-free document-oriented database accessible via a RESTful HTTP / JSON API.
- 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…
- MongoDB: MongoDB is a cross-platform, open-source document-oriented NoSQL database that stores data in flexible, JSON-like BSON documents instead of…
- 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.
- postgresql: PostgreSQL (Postgres) is an open source object-relational database known for reliability and data integrity.

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