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.

We ran into the same issue.

你好,

我一直在嘗試借助 .env 檔案來更改生產伺服器中的密碼。 但由於更改資料庫密碼後無法與 postgres 使用者進行身份驗證,導致後端出現問題。

psql: FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "postgres"
這不是我要做的就是更改密碼嗎?

提前致謝。 埃文

你好,

我一直在嘗試借助 .env 檔案來更改生產伺服器中的密碼。 但由於更改資料庫密碼後無法與 postgres 使用者進行身份驗證,導致後端出現問題。

psql: FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "postgres"
這不是我要做的就是更改密碼嗎?

提前致謝。 埃文

抱歉..剛下班,不太會用,搞了好久才...

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