Re: FATAL: database "xxx" does not exist when it does
| От | Siddharth Jain |
|---|---|
| Тема | Re: FATAL: database "xxx" does not exist when it does |
| Дата | |
| Msg-id | CAPqV3pQaDqJUOQBxiRQED8JoixNToey6A8LgvA20HYiQ2Z09AQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: FATAL: database "xxx" does not exist when it does
Re: FATAL: database "xxx" does not exist when it does |
| Список | pgsql-general |
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/postgresbut user sysbench is not able to connect to this database:sysbench=> \c xxx
FATAL: database "xxx" does not exist
Previous connection kepthow can i fix this?
В списке pgsql-general по дате отправления: