How to properly configure PostgreSQL?

Question

PostgreSQL

Good day to all. I must say right away that before that I worked with MySQL (MariaDB), now I decided to try PostgreSQL. Please tell me how to set it up correctly. After installation, the postgres user was automatically created in the system. Next, you need to log in under it and create a database. But then I don’t understand, in the instructions I’m offered to create a user from under postgres. I tried but I can't get in. Then I created a user, as it is done in mysql, right in the SQL shell, wrote GRANT to him, and then everything worked. And in the end, I still did not understand how to create or create a real Linux Account in the SQL shell. Maybe I'm missing something, point me in the right direction. Thanks in advance.

Answer 1

Postgres supports many authentication schemes . In any case, the user must be created in the database. But there is a peer mode in which the current OS user can connect to the database as the database user of the same name. Obviously, this only works for local connections and serves primarily for some administrative tasks. To connect applications to the database, it is better to use password authentication .
So the question is not in correctness, but in tasks.