I am unable to connect to my postgres DB within the same project and get the error stating that password authentication failed.

This error has occurred without any deployment or change. I have tried resetting the password, using the public URL, but nothing is working.