Question: how to create user for specific 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.