Re: FATAL: database "xxx" does not exist when it does

Even on the create role you set login?

Rodrigo Dev

Visite: https://rodrigoluna.net.br

YouTube: GamesBR

Em 1 de fev. de 2023, à(s) 17:13, Siddharth Jain <siddhsql@gmail.com> escreveu:



using Postgres 14.4, I created a database as the postgres user:

create database xxx;

postgres=> \c xxx
psql (13.9 (Debian 13.9-0+deb11u1), server 14.4)
WARNING: psql major version 13, server major version 14.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
You are now connected to database "xxx" as user "postgres".

i gave all privileges on xxx to user sysbench:

postgres=> GRANT ALL PRIVILEGES ON DATABASE xxx TO sysbench;

i can see:

Name     |      Owner       | Encoding | Collate |  Ctype  |           Access privileges
--------------+------------------+----------+---------+---------+---------------------------------------
 xxx         | postgres         | UTF8     | C.UTF-8 | C.UTF-8 | =Tc/postgres                         +
              |                  |          |         |         | postgres=CTc/postgres                +
              |                  |          |         |         | sysbench=CTc/postgres

but user sysbench is not able to connect to this database:

sysbench=> \c xxx
FATAL:  database "xxx" does not exist
Previous connection kept

how can i fix this?