MaskedMatters Posts - Answer Overflow

MaskedMatters

•Created by MaskedMatters on 4/24/2025 in #help-desk-support

Postgres Password Authentication Failure After Restore

Hello everyone, I just recently wanted to redo my home lab so I could add a reverse proxy and use different hardware so I followed the Backup & Restore steps on the Immich website so I could set it back up later. It just came time to restart my Immich instance and I've been running into a problem where the immich_server container keeps giving me this error:

[Nest] 7  - 04/24/2025, 7:29:15 PM     LOG [Microservices:EventRepository] Initialized websocket server
microservices worker error: PostgresError: password authentication failed for user "postgres", stack: PostgresError: password authentication failed for user "postgres"
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1

[Nest] 7  - 04/24/2025, 7:29:15 PM     LOG [Microservices:EventRepository] Initialized websocket server
microservices worker error: PostgresError: password authentication failed for user "postgres", stack: PostgresError: password authentication failed for user "postgres"
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1

The first thing I did was setup a fresh instance with the docker-compose.yaml file and .env file and I kept the password default since I didn't save the password from my last Immich instance (which I hope is okay). I followed the restoration steps by pulling and creating the containers, starting the Postgres database, and restoring it. Once I started all the other containers, this error is on repeat in the server container and keeps restarting. My docker-compose.yaml file and .env file are too long to fit in this post but I got the files straight from the GitHub repo and I only changed my timezone to America/New_York in the environment file.

25 replies

Gaming

Programming