Changing passwords in the .env file produces failure to authenticate with postgres user #344

Activity

2. tiangolo

   added

   investigate

   on Nov 14, 2022
3. emirakdere commented on Sep 17, 2024

   

   emirakdere

   on Sep 17, 2024

   Last edited by emirakdere

   More actions

   Just upvoting that I ran into the same issue today, I think even a simple clarification on the readme would be a nice patch as a troubleshooting step.
4. alejsdev

   added a commit that references this issue on Dec 19, 2024

   👷 Run tests using Python env, setup with uv, and add tests to check D…

   ...

   845c850
5. bironeaj commented on Jan 23, 2025

   

   bironeaj

   on Jan 23, 2025

   More actions

   We ran into the same issue.
8. sfxgg commented on Mar 23, 2025

   

   sfxgg

   on Mar 23, 2025

   More actions

   I ran into the same issue after modifying the default password for PG, deleting the db volume manually and rerunning docker compose watch resolved the issue.

   Hello ! I got the same problem and for me it was due to the volume creation of docker you can check that with :

   docker volume ls

   I'm not an expert in Docker but I think if you change the password in the .env it does not create a new volume or use the old one to connect with your new password and that will obviously not work.

   From this constatation you have 2 solution the first one is more or less "brutforce" and it worked for me the second one is maybe more smart but i didn't test it:

   1. Delete the old volume and build the image again with docker-compose
   

   docker volume rm <old_db_volume_id>

   or to delete every single volume

   docker volume rm $(docker volume ls)

   then build your project image again

   docker-compose up -d

   2. Access to the pg admin or directly form the shell (with docker commands) to access to your db_user and change the password (I didn't test is with docker but I've already done this on a running server I don't remember the commands tho)
   

   Hope this will help you :) Do not hesitate to correct me or complete my answer
9. fastapi

   locked and limited conversation to collaborators on Sep 1, 2025
10. YuriiMotov

    converted this issue into a discussion #1821 on Sep 1, 2025