The latest articles on DEV Community by CharlieSchwab (@charlieschwab). https://dev.to/charlieschwab https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F558460%2Fb5f9aba5-6b0e-4696-86c7-9c55baa9564e.png https://dev.to/charlieschwab en CharlieSchwab Wed, 13 Jan 2021 06:18:33 +0000 https://dev.to/charlieschwab/postgres-authentication-problem-58nn https://dev.to/charlieschwab/postgres-authentication-problem-58nn <p>Hello, everyone.<br> I'm new to this community. I don't know if my first post should have been an introduction of myself.<br> But currently I've got a pressing matter at hand.<br> I've searched stackoverflow and almost all documents google could provide. Still my problem is unsolved.<br> I'm trying to run a server on VPS.<br> The user and database is created. And I've configured the authentication method into md5 in the following file.</p> <p>/etc/postgresql/12/main/pg_hba.conf</p> <p>Yet, when I try to login with the following URL, I get an error<br> [password authentication failed for user "username"]</p> <p>DATABASE_URL=postgres://username:@localhost/dbname</p> <p>Please help me solve this problem.</p> postgres