Update or clean install v1.122.1: password authentication failed for user "postgres"
Things were working fine, started facing this error after updating to v1.122.1. Haven't done any changes.
Decided to do a fresh install by deleting all images, containers, volumes pruned, deleted stack and recreated. Still stuck with same issue.
Attached docker compose, env and the server log files.
Please help, thanks in advance!
19 Replies
:wave: Hey @SJ,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Checklist
I have...
1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
2. :blue_square: read applicable release notes.
3. :blue_square: reviewed the FAQs for known issues.
4. :blue_square: reviewed Github for known issues.
5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: uploaded the relevant information (see below).
7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.Please let me know if more details are needed. I've also tried changing username to something else, the error message still shows "postgres". I'm on portainer if it helps.
I'm assuming you started postgres and then later changed the password?
Thanks for responding @Daniel . I did not do any changes on the fresh install, the initial setup itself is failing now with this error.
You're starting from scratch, right?
Yes, I've cleared everything and started fresh. I'm on synology NAS, setup immich on portainer stack.
Then just
docker compose down the stack, delete the content of the postgres folder and start it up againThanks! Let me try it and get back to you.
A small clarification please. As I'm on portainer, the corresponding approach is stop all the containers in the stack, delete the postgres folder content and then re-deploy the stack? Should i also delete the postgres container?
You don't need to ping me with every message :)
(1) Yes. (2) You don't need to
Sorry, a bad habit 🙂 Stopped the stack, deleted the volume folder content, redeployed. I'm still seeing the same error in immich_server logs.
Error logs are same as the initial log file I've attached.
Oh hold on why have you even defined
DATABASE_URL in your compose file?
In general the environment on the immich server is like very weirdI think i found this piece on one of the forums while searching to enable hardware acceleration.
environment:
- NODE_ENV=production
- DATABASE_URL=postgresql://${DB_USERNAME}:${DB_PASSWORD}@database/${DB_DATABASE_NAME}
- TRANSCODE_HWACCEL=quicksync
That is like completely wrong
Sounds like haluscinating AI to me 😅
https://immich.app/docs/install/portainer Please refer to the official install guide
Oh boy! Alright, let me start fresh again 😆
Sorry :/
My mistake anyways! Is it recommended to setup everything at once? Or can I first do the basic setup and add hardware acceleration at a later point of time?
That literally doesn't matter at all for Immich
So you can absolutely take it slow :)
Finally! You are the savior Daniel, I owe you one 🙂 Things are fine again, got to go through one more round of TBs of data scan, but it's worth it!
Learned something new today. My mistake was considering something outside the official documentation to setup immich on Portainer (Also missed env_file: stack.env).(face_palm) 😫
Awesome, glad you got it all sorted! :D
And yeah, not referring to the official documentation is often times a rather bad idea :P