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.