# Immich PostgreSQL

Immich PostgreSQL is a PostgreSQL database container purpose-built to power the Immich self-hosted photo and video gallery. It is open source and self-hosted, installable on TrueNAS and Proxmox.

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

## Description

Immich PostgreSQL is a PostgreSQL database container purpose-built to power the Immich self-hosted photo and video gallery. It stores and indexes the metadata and media information behind Immich so the main application can search and retrieve your photos and videos quickly and reliably. It is intended for homelab users who self-host Immich and prefer the database container from Immich's official stack over configuring a generic PostgreSQL server.

## Platform availability

Available on 2 of 10 platforms: TrueNAS, Proxmox.

## Health score

66/100 (Good), based on 4 of 5 factors.
- Maintained: 100 (last commit 3 days ago)
- Popular: 39 (86 GitHub stars)
- Easy to install: 15 (0 install platforms, install notes)
- Security check: 85 (no serious findings, CI)

## Links

- GitHub: https://github.com/immich-app/base-images
- TrueNAS: https://apps.truenas.com/catalog/immich
- Proxmox: https://community-scripts.github.io/ProxmoxVE/scripts?id=immich
- Official website: https://immich.app

## Common questions

### How should I handle the PostgreSQL data folder when moving or backing up Immich?

Copy the PostgreSQL data folder from the container to a mounted host directory.

### What can happen if PostgreSQL data is not persisted across a Docker deployment?

A user reported that Immich forgot about 100 GB of photos and asked them to register again after an update.

### What happened to the database when a TrueNAS user migrated Immich from 24.04 to 24.10?

The PostgreSQL database did not carry over, so the app started with an empty database.

### What storage failures should self-hosters consider for long-term Immich data?

Bitrot and hard disk failure are raised as concerns for long-term reliable usage.

## Alternatives

- ChronoFrame: ChronoFrame is a self-hosted photo gallery for homelab users who want a private, low-maintenance place to upload, organize, and share perso…
- Ente Photos: Open-source, end-to-end encrypted backup and sharing for photos and videos, with multi-platform sync, original quality, privacy controls, a…
- Frameleaf Manager: Frameleaf Manager is the guided installer and upgrade tool for the self-hosted Frameleaf photo and video library.
- Go-vod: Go-vod is a minimal, self-hosted video transcoding server for the Memories Nextcloud photo app that exposes stored media as HTTP Live Strea…
- Google Photos: Cloud storage offering 15 GB free space, automatic album and duplicate organization, AI editing, cross-platform sharing, and secure backups.
- HomeGallery: HomeGallery is a self-hosted, open-source web gallery for browsing personal photos and videos while keeping your original file and folder s…
- PhotoPrism: PhotoPrism is a self-hosted, AI-powered photo and video manager.
- Piwigo: Piwigo is a self-hosted, open-source photo gallery for the web that lets you publish, organise, and share your picture collection with powe…
- Proton Drive: Emphasizes privacy with end-to-end encryption, Proton Drive safely stores, synchronizes, and shares files across devices via web and mobile…
- TinyCld: Open source suite for mail, calendar, drive, and contacts with self-hosting, privacy, zero cost, open standards, versioned files, and unifi…
- foldergram: Foldergram is a self-hosted, local-first web gallery that scans folders for photos and videos and displays them in a fast, Instagram-style…
- librephotos: LibrePhotos is a self-hosted, open-source photo management service for organizing and browsing photo and video collections.

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