Cant restore from backup - database auth fail

[HelloMihai]

I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

• Yes

The bug

restoring from immich automatic backup fails when starting containers due to authentication failure with user "postgres"

this is a fresh new volume and images pull

docker compose has custom password for postgres. Same password, never changed... in new build or duration of backups.

desired backup source location"
/home/myuser/docker/immich_backup/backups/immich-db-backup-1741744800030.sql.gz

after restoring, immich_server fails to authenticate with the DB

I have tried:

1. console into the immich_postgres container and manually setting the password

myuser@server:~/docker/immich$ docker-compose up -d
myuser@ server:~/docker/immich$ docker exec -it immich_postgres bash
# inside immich_postgres container
root@123456abcdefg:/# psql -U postgres -d immich

## see all users, only postgres listed
immich=# \du

immich=# ALTER USER postgres WITH PASSWORD 'mycustompassword123';

2. checking postgres permissions and setting to my user

ls -ld /home/myuser/docker/immich/postgres ## ownser was root likely due to sudo in backup command
sudo chown -R myuser:myuser /home/myuser/docker/immich/postgres
ls -ld /home/myuser/docker/immich/postgres ## owner changed to myuser

The OS that Immich Server is running on

Ubuntu Server 24.04

Version of Immich Server

v1.129.0

Version of Immich Mobile App

v1.129.0 build.197

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

name: immich

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}transcoding
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
      - ${PHOTO_LIBRARY_PATH}:${IMMICH_IMPORT_PATH}:ro  # Map 4T SSD Photos directory, :ro = read only
    ports:
      - 2283:2283
    depends_on:
      - redis
      - database
    restart: always
    healthcheck:
      disable: false

  immich-machine-learning:
    container_name: immich_machine_learning
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    volumes:
      - model-cache:/cache
    restart: always
    healthcheck:
      disable: false

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:905c4ee67b8e0aa955331960d2aa745781e6bd89afc44a8584bfd13bc890f0ae
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always

  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    command: >-
      postgres
      -c shared_preload_libraries=vectors.so
      -c 'search_path="$$user", public, vectors'
      -c logging_collector=on
      -c max_wal_size=2GB
      -c shared_buffers=512MB
      -c wal_compression=on
    restart: always

volumes:
  model-cache:

Your .env content

UPLOAD_LOCATION=/home/myuser/docker/immich/library
DB_DATA_LOCATION=/home/myuser/docker/immich/postgres
PHOTO_LIBRARY_PATH=/mnt/nfs_mounted_library
IMMICH_IMPORT_PATH=/usr/src/app/import
IMMICH_VERSION=release
DB_PASSWORD=mycustompassword123
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

Reproduction steps

1. ssh into server
2. cd to docker compose path
3. execute commands from docs

myuser@server: $ cd /home/myuser/docker/
myuser@server:/home/myuser/docker $ mkdir -p immich/library

myuser@server:/home/myuser/docker $ cd immich
myuser@server:/home/myuser/docker/immich $ sudo docker compose pull
myuser@server:/home/myuser/docker/immich $ sudo docker compose create
myuser@server:/home/myuser/docker/immich $ sudo docker start immich_postgres
myuser@server:/home/myuser/docker/immich $ sleep 10
myuser@server:/home/myuser/docker/immich $ sudo docker ps | grep immich ## confirm immich_postgres container is running

myuser@server:/home/myuser/docker/immich $ gunzip < "/home/myuser/docker/immich_backup/backups/immich-db-backup-1741744800030.sql.gz" \
| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \
| sudo docker exec -i immich_postgres psql --dbname=postgres --username=postgres

log from restore

SET
SET
SET
DROP DATABASE
ERROR:  current user cannot be dropped
ERROR:  role "postgres" already exists
ALTER ROLE
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
UPDATE 1
DROP DATABASE
CREATE DATABASE
ALTER DATABASE
You are now connected to database "template1" as user "postgres".
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
COMMENT
ALTER DATABASE
You are now connected to database "template1" as user "postgres".
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
REVOKE
GRANT
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
CREATE DATABASE
ALTER DATABASE
You are now connected to database "immich" as user "postgres".
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
ALTER DATABASE
You are now connected to database "immich" as user "postgres".
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
COMMENT
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 20
COPY 4
COPY 30151
COPY 7
COPY 1
COPY 229107
COPY 317982
COPY 161894
COPY 1
COPY 161894
COPY 3318
COPY 161894
COPY 228813
COPY 210499
COPY 1
COPY 110
COPY 1390
COPY 192
COPY 0
COPY 4274
COPY 1
COPY 0
COPY 5178
COPY 0
COPY 39
COPY 10490
COPY 61
COPY 158898
COPY 0
COPY 0
COPY 7
COPY 553
COPY 19
COPY 19
COPY 1
COPY 5
COPY 0
COPY 11
 setval 
--------
   3318
(1 row)

 setval 
--------
    192
(1 row)

 setval 
--------
   4274
(1 row)

 setval 
--------
      1
(1 row)

ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
DROP DATABASE
CREATE DATABASE
ALTER DATABASE
You are now connected to database "postgres" as user "postgres".
SET
SET
SET
SET
SET
     set_config     
--------------------
 public, pg_catalog
(1 row)

SET
SET
SET
SET
COMMENT

Relevant log output

immich_server            | Starting api worker
immich_server            | Starting microservices worker
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [NestFactory] Starting Nest application...
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] BullModule dependencies initialized +1ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
immich_server            | error: password authentication failed for user "postgres"
immich_server            |     at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
immich_server            |     at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
immich_server            |     at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
immich_server            |     at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
immich_server            |     at Socket.emit (node:events:524:28)
immich_server            |     at addChunk (node:internal/streams/readable:561:12)
immich_server            |     at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich_server            |     at Readable.push (node:internal/streams/readable:392:5)
immich_server            |     at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] ClsModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] ClsCommonModule dependencies initialized +1ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] OpenTelemetryModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] KyselyModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] KyselyCoreModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] OpenTelemetryCoreModule dependencies initialized +1ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] DiscoveryModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] ClsRootModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] ScheduleModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] BullModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM     LOG [InstanceLoader] BullModule dependencies initialized +0ms
immich_server            | [Nest] 17  - 03/18/2025, 5:37:43 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (2)...
immich_server            | error: password authentication failed for user "postgres"
immich_server            |     at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
immich_server            |     at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
immich_server            |     at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
immich_server            |     at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
immich_server            |     at Socket.emit (node:events:524:28)
immich_server            |     at addChunk (node:internal/streams/readable:561:12)
immich_server            |     at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich_server            |     at Readable.push (node:internal/streams/readable:392:5)
immich_server            |     at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

...
...


immich_server            |   length: 104,
immich_server            |   severity: 'FATAL',
immich_server            |   code: '28P01',
immich_server            |   detail: undefined,
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: undefined,
immich_server            |   table: undefined,
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: undefined,
immich_server            |   file: 'auth.c',
immich_server            |   line: '335',
immich_server            |   routine: 'auth_failed'
immich_server            | }
immich_server            | api worker exited with code 1

Additional information

No response

[HelloMihai]

Also tried on Mac osx where docker doesn’t require sudo like the initial headless Linux server. Same result. Can’t connect to database due to authorization.

[HelloMihai]

as a test I was able to restore from a manually created backup using documented command from https://immich.app/docs/administration/backup-and-restore

docker exec -t immich_postgres pg_dumpall --clean --if-exists --username=postgres | gzip > "/path/to/backup/dump.sql.gz"

I did have to create the subfolders in library and the .immich files but it worked.

I still need to restore from the automatically created backup :-(

[HelloMihai]

I have manually tried to authenticate in the postgres container with the password set in the .env and it works. So im not sure why the app cant log in when starting

root@698978b70fab:/# psql -h database -U postgres -d immich
Password for user postgres: 
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

immich=# \list
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 immich    | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(4 rows)

[HelloMihai]

I verified the db username and password are correct

from the immich_server container console, I logged in to the psql database with the password from the .env file and ran a query verifying the password works and the db contains the correct information.

from the immich_postgres container any password works since its local and trusted

immich_server container console:

# psql -h localhost -U postgres -d immich -W
Password: 
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# SELECT COUNT(*)
FROM public.asset_faces
WHERE "personId" = (SELECT id FROM public.person WHERE "name" = 'Cezar');
 count 
-------
   103
(1 row)

immich=# 

but im still seeing the same immich_server error

[Nest] 17  - 03/22/2025, 4:02:15 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (9)...
2025-03-21 21:02:15 immich_server            | error: password authentication failed for user "postgres"

I tried with a manually created backup and everything works fine... for some reason I just cant get the server to connect to the db from that automatic backup I really need to restore to

[HelloMihai]

SOLVED

found the issue... docker-compose.yml file was missing the env file specification thus it was never using the db password and name information

[masterbeancoder]

I seem to be having the same issue. Can you clarify where the env file specification was missing? I'm probably just misunderstanding as I'm fairly new to docker and postgres in general, but in my docker-compose.yml file, it looks like my .env file is specified twice (see below). I am doing this as a test in preparation for moving my currently working instance from a vm on my desktop to one on my NAS, so I'm not really worried about losing data, as this is a backup from a few weeks ago.

name: immich

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
    # extends:
    #   file: hwaccel.transcoding.yml
    #   service: cpu # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
    volumes:
      # Do not edit the next line. If you want to change the media storage location on your system, edit the value o
f UPLOAD_LOCATION in the .env file
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - /etc/localtime:/etc/localtime:ro
    env_file:
      - .env
    ports:
      - 2283:2283
    depends_on:
      - redis
      - database
    restart: always
    healthcheck:
      disable: false

  immich-machine-learning:
    container_name: immich_machine_learning
    # For hardware acceleration, add one of -[armnn, cuda, openvino] to the image tag.
    # Example tag: ${IMMICH_VERSION:-release}-cuda
    image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
    # extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware
-acceleration
    #   file: hwaccel.ml.yml
    #   service: cpu # set to one of [armnn, cuda, openvino, openvino-wsl] for accelerated inference - use the `-wsl
` version for WSL2 where applicable
    volumes:
      - model-cache:/cache
    env_file:
      - .env
    restart: always
    healthcheck:
      disable: false

  redis:
    container_name: immich_redis
    image: docker.io/redis:6.2-alpine@sha256:e3b17ba9479deec4b7d1eeec1548a253acc5374d68d3b27937fcfe4df8d18c7e
    healthcheck:
      test: redis-cli ping || exit 1
    restart: always

  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd64
63e3fa298f0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the valu
e of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    healthcheck:
      test: pg_isready --dbname='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' || exit 1; Chksum="$$(psql --dbnam
e='${DB_DATABASE_NAME}' --username='${DB_USERNAME}' --tuples-only --no-align --command='SELECT COALESCE(SUM(checksum
_failures), 0) FROM pg_stat_database')"; echo "checksum failure count is $$Chksum"; [ "$$Chksum" = '0' ] || exit 1
      interval: 5m
      start_interval: 30s
      start_period: 5m
    command: ["postgres", "-c", "shared_preload_libraries=vectors.so", "-c", 'search_path="$$user", public, vectors'
, "-c", "logging_collector=on", "-c", "max_wal_size=2GB", "-c", "shared_buffers=512MB", "-c", "wal_compression=on"]
    restart: always

volumes:
  model-cache:

[masterbeancoder]

Ok, after some more digging through logs, I guess it may just be that I need to create my .immich file. Did you need to put anything in it or does it just need to exist? This is my server log.

[Nest] 17  - 04/28/2025, 3:09:16 PM   ERROR [Api:StorageService] Failed to read upload/library/.immich: Error: ENOENT: no such file or directory, open 'upload/library/.immich'
api worker exited with code 1

[masterbeancoder]

Well, I figured it out! Evidently the problem was that I both didn't have all my .immich files and I was missing my /library subdirectory along with it's .immich file. I added them (as per this other post I found) and everything worked perfectly!