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?
