postgreSQL password authentication failed for user

Question

I'm taking a full WebDev course and got really hard stuck on this matter. I've installed postgreSQL 14.2 for Windows 10 and the instructor said that pgAdmin4 would come together, which it didn't, so then i installed pgAdmin4 individually. I've setted everything up and created a testing database, which is called 'test', and also a table, everything through Windows Powershell command lines, following the course instructions. Now, when i try to access this database through PowerShell command psql 'test' and type the requested password for the OS user i get a Fatal Error, which follows:

PS C:\Users\theu_\desktop> psql 'test'
Password for user theu_:
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "theu_"

I've tried my OS username password and the postgreSQL password, none of them works. What am i missing or did wrong?

Thanks in advance

NodeToNowhere · Accepted Answer · 2022-03-16 03:36:38Z

22

Try accessing postgres by using psql -U postgres in cmd, postgres being the name of the superuser for postgres itself (if you did a basic install) - while windows is probably trying to access postgres with your windows name.

You should also be able to use SQL Shell to access your database without denoting a user.

edited Mar 16, 2022 at 3:36

answered Mar 16, 2022 at 3:25

NodeToNowhere

3362 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgreSQL password authentication failed for user

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related