password authentication failed for user "postgres" | Immich | Page 1

untold smelt Mar 31, 2025, 2:41 PM

#

after trying to update server in dockage postgres keeps saying password auth failed, i have not changed the password in the .env, i also tried to make a .env file with the same information in dockage in the same folders but the issue still persists

long pikeBOT Mar 31, 2025, 2:41 PM

#

:wave: Hey @untold smelt,

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...

:ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: read applicable release notes.
:ballot_box_with_check: reviewed the FAQs for known issues.
:ballot_box_with_check: reviewed Github for known issues.
:ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
:ballot_box_with_check: uploaded the relevant information (see below).
:ballot_box_with_check: 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.

long pikeBOT Mar 31, 2025, 2:43 PM

#

long pike ## Checklist I have... 1. :ballot_box_with_check: verified I'm on the latest rel...

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

untold smelt Mar 31, 2025, 2:44 PM

#

i have made sure to use the current docker compose and .env files, and just adjusted db password

frail oyster Mar 31, 2025, 2:44 PM

#

untold smelt i have made sure to use the current docker compose and .env files, and just adju...

i have not changed the password in the .env,

and just adjusted db password
Did you change the password or no?

#

You're making contradictory statements 😅

untold smelt Mar 31, 2025, 2:45 PM

#

i changed the db pw in the .env after re copying it to the same password i already had

frail oyster Mar 31, 2025, 2:46 PM

#

I don't follow

#

Why/when has the password changed in the .env file?

#

Why did you have to paste it there again?

untold smelt Mar 31, 2025, 2:46 PM

#

i just re copied the cocmpose and env file from the github to make sure it was correct

#

then changed the pw in the newly copied env to the pw i set

frail oyster Mar 31, 2025, 2:47 PM

#

There's no need to do that

#

From which version did you upgrade?

#

How did your old compose and env file look like?

untold smelt Mar 31, 2025, 2:47 PM

#

130.2

#

it should have been the defult, i didnt change anything

frail oyster Mar 31, 2025, 2:48 PM

#

What are you using exactly? Which OS? etc.

#

I'm not aware of "dockage"

untold smelt Mar 31, 2025, 2:48 PM

#

proxmox lxc using dockage

frail oyster Mar 31, 2025, 2:49 PM

#

I have no clue what dockage is

#

But docker in lxc is unsupported

untold smelt Mar 31, 2025, 2:51 PM

#

its similar to portainer

#

but much simpler

frail oyster Mar 31, 2025, 2:51 PM

#

Do you mean dockge?

untold smelt Mar 31, 2025, 2:52 PM

#

yes my bad

frail oyster Mar 31, 2025, 2:52 PM

#

Gotcha

frail oyster Mar 31, 2025, 2:52 PM

#

frail oyster But docker in lxc is unsupported

Then this still applies though

untold smelt Mar 31, 2025, 2:53 PM

#

is that an issue with proxmox? or just immich?

frail oyster Mar 31, 2025, 2:54 PM

#

Proxmox officially says that you shouldn't be running docker inside LXC

untold smelt Mar 31, 2025, 2:56 PM

#

okay i was not aware of that, but this doesn't seem to be a docker issue to me, its just not getting the correct pw?

solar kiln Mar 31, 2025, 2:56 PM

#

You can try changing the DB password as shown here

https://immich.app/docs/guides/database-queries/

if that doesn’t work we would ask you to move to a supported (VM) install and or reach out to the team that produced/supports the LXC

frail oyster Mar 31, 2025, 2:57 PM

#

untold smelt okay i was not aware of that, but this doesn't seem to be a docker issue to me, ...

To me it sounds a bit like your database may be lost or something. I don't see another reason how it could have reverted back to the default password

#

Oh actually

#

How did you start the stack again after changing your .env file?

untold smelt Mar 31, 2025, 3:00 PM

#

solar kiln You can try changing the DB password as shown here https://immich.app/docs/gui...

this fixed it

untold smelt Mar 31, 2025, 3:01 PM

#

frail oyster How did you start the stack again after changing your .env file?

i stopped everything, changed the files, then did compose up

frail oyster Mar 31, 2025, 3:01 PM

#

untold smelt i stopped everything, changed the files, then did compose up

Yeah ok compose up should've applied the changes

frail oyster Mar 31, 2025, 3:01 PM

#

untold smelt this fixed it

Is your database still there?

untold smelt Mar 31, 2025, 3:01 PM

#

yeah everything looks good

frail oyster Mar 31, 2025, 3:01 PM

#

Are you sure it was using your password before then?

untold smelt Mar 31, 2025, 3:02 PM

#

im not 100% certin, but i changed the pw to what i set it to and then it worked

frail oyster Mar 31, 2025, 3:04 PM

#

Yeah, so it must've not been that password in the past :P

untold smelt Mar 31, 2025, 3:04 PM

#

i will look into migrating to a VM ofr the future

frail oyster Mar 31, 2025, 3:04 PM

#

Anyways. We still recommend moving to a VM, since we have in fact seen weird (in parts irrecoverable) issues with running docker in proxmox LXC in the past

frail oyster Mar 31, 2025, 3:05 PM

#

untold smelt i will look into migrating to a VM ofr the future

Ha nice!

untold smelt Mar 31, 2025, 3:05 PM

#

im guessing dockge doesn't pass through the .env that well? that's my best guess

#

or i did something wrong, much more likely....

frail oyster Mar 31, 2025, 3:07 PM

#

¯_(ツ)_/¯

untold smelt Mar 31, 2025, 3:08 PM

#

thanks for the assistance!

#password authentication failed for user "postgres"

References

Checklist

Information