U
U
user_of_toster2020-11-26 13:41:59
PostgreSQL
user_of_toster, 2020-11-26 13:41:59

What password does PostgreSQL ask for?

Installed PostgreSQL on windows via installer. During installation, I entered the password asdasdasd

I enter psql or createdb into the console, writes:

Enter password for %windows_user_name%


I enter the password from Windows, the password that I specified during installation (asdasdasd), I enter a space, I just press the inter - the user writes was not authenticated by password

Question - how should I guess what password I should enter? Why does it ask for a password from a Windows user, and not a postgres super user?

UPD: Everything works fine if you type psql -U postgres. However, the question why postgres asks for a password from a user with the same nickname as the windows user is not clear at all.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-11-26
@user_of_toster

However, the question why postgres asks for a password from a user with the same nickname as the windows user is not clear at all.

Because that's the default. If you did not specify the username yourself, the name of the current system user is taken.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question