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.