Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Change the owner to xxx too.

Rodrigo Dev
Visite: https://rodrigoluna.net.br
YouTube: GamesBR

Em 1 de fev. de 2023, à(s) 17:15, Rodrigo Luna <rodrigomrluna78@xxxxxxxxx> escreveu:

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux