cant create a database in DBeaver

Question

im just starting using databases and I'm working with PostgreSQL using Dbeaver. When I want to create database,i need to create a new connection ,so I select PostgreSQL in the window then I press next and this windows pops up and no matter what I write in User ,Database or Password Field it always show the same error

FATAL:role "(what I typed in the User field,for example misha)" does not exist

Please Help.

Answer 1

You should create a new role named misha.

I assume you are using GUI, if so you could just right click on Login Roles menu and create a the role.

Here's the query to do it manually :

CREATE ROLE misha LOGIN UNENCRYPTED PASSWORD 'misha'
  SUPERUSER
   VALID UNTIL 'infinity';