>
>
>
> 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?
>>
>