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…

  • Databases
  • Network Services
  • Productivity
  • Tools & Utilities
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 10 platforms

  • Unraid
  • TrueNAS
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox
  • 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.

75/100 Good

Maintained
99last commit 36 days ago
Popular
100116,397 GitHub stars
Easy to install
351 install platform, install notes, Docker image
Light to run
206 GB minimum RAM, runs on ARM

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

No GitHub repository data collected yet.

Resources & Compatibility

Minimum requirements: 6 GB RAM, 2 CPU core(s). ARM (e.g. Raspberry Pi) is supported.

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

First-install notes

  • Start PostgreSQL automatically on OpenBSD If you use OpenBSD, add the example lines to /etc/rc.local (the small startup script that runs when the machine boots) so PostgreSQL starts after a reboot. Without this, the server can be off after restart and Immich won’t be able to reach its database. source
  • Matching Immich Database Configuration Defaults are superuser 'postgres', password 'postgres', and database 'postgres'. If you change POSTGRES_PASSWORD, POSTGRES_USER, or POSTGRES_DB in this container you must mirror the same values in the Immich container's environment variables or Immich will fail to connect. source

Fetched 37 days ago - each note links to its source

Alternatives (1)

  • 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…

Checked 40 days ago - source: AlternativeTo

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.

Answers sourced from forums.unraid.net, mustafa.net, www.postgresql.org, www.reddit.com

Community

Collected 48 days ago - public community threads