Question: how to create user for database in postgresql?
Answer: At the command line, type the following command as the server's root user: su - postgres.
You can now run commands as the PostgreSQL superuser. ... 
At the Enter name of role to add: prompt, type the user's name.
At the Enter password for new role: prompt, type a password for the user.