← Directory

PostgreSQL_Immich

This container (based on PostgreSQL 16) is specifically configured for seamless integration with the Immich container, which requires PostgreSQL equipped with…

  • Network Services
  • Productivity
  • Tools & Utilities
This container (based on PostgreSQL 16) is specifically configured for seamless integration with the Immich container, which requires PostgreSQL equipped with pgvecto a robust Postgres extension enabling vector similarity search functions. The specific version used is tensorchord/pgvecto-rs:pg16-v0.3.0 Configuration Parameters POSTGRES_PASSWORD - Superuser password. Default postgres Note -- If you change this value, remember to update it in the Immich container configuration as well. POSTGRES_USER - Username for the superuser. Default postgres Note -- Alterations to this setting should also be mirrored in the Immich container. POSTGRES_DB - Default database. Default: postgres Note -- Any change here should be replicated in the Immich container configuration. Storage Data and Configuration Path: /mnt/user/appdata/postgresql_immich This is the directory where Postgres stores its

Platform availability

Available on 3 of 9 platforms

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

29/100 Low

Maintained
No data
Popular
No data
Easy to install
351 install platform, install notes, Docker image
Light to run
206 GB minimum RAM, runs on ARM

Based on 2 of 4 factors.

Availability: platform listings confirmed today, links checked 13 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 14 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

Fetched 14 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 - Apache CouchDB is a document database that stores JSON data and speaks HTTP, with built-in replication, change tracking, and flexible views…
  • 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.

Checked today - 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 8 days ago - public community threads