PostgreSQL gives user doesn't exists when user exists

Question

To create user I executed the following queries:

CREATE DATABASE yourdbname;
CREATE USER username WITH ENCRYPTED PASSWORD 'yourpass';
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO username;

I check if user was created this way:

su postgres
bash-4.2$ psql -h localhost -p 5432
psql (12.2)
Type "help" for help.
postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
 username  |                                                            | {}

postgres=#

And now, when I want to connect:

$psql -h localhost -p 5432 -U username
psql: error: could not connect to server: FATAL:  database "username" does not exist

Could anyone say how to fix it?

pifor · Accepted Answer · 2020-04-22 10:21:46Z

0

Try:

$ psql -h localhost -p 5432 -U username yourdbname

answered Apr 22, 2020 at 10:21

pifor

7,9722 gold badges11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amjad Shahzad · Accepted Answer · 2020-04-22 10:34:54Z

0

By default the psql always consider your default database name same as your user name. So to overcome this, make sure you are using -d dbname while connecting to database.

e.g ./psql -h localhost -p 5432 -d yourdbname -U username

answered Apr 22, 2020 at 10:34

Amjad Shahzad

8427 silver badges15 bronze badges

Collectives™ on Stack Overflow

PostgreSQL gives user doesn't exists when user exists

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related