PG::ConnectionBad: FATAL: password authentication failed for user "deploy" capistrano rails

Hi

I am working on deploying rails application to digital ocean everything is worked fine. just stuck on that final step:
when I am runing

cap production deploy

I am getting

01 PG::ConnectionBad: FATAL: password authentication failed for user "deploy"
01 FATAL: password authentication failed for user "deploy"

error I check multiple links online to solve this issue but no luck.

I also check pg status and it's running
I also ran

psql -U deploy -W -h 127.0.0.1 -d markketer_production

and it's also working let me know if you have idea about this issue

thanks

This might be late but I had the same error. First place to look at was in the environment variables.

nano /home/deploy/myapp/.rbenv-vars