Postgres Pro
Downloads
Home   >   mailing lists

Re: database "cdf_100_1313" does not exist - Mailing list pgsql-general

From nikhil raj
Subject Re: database "cdf_100_1313" does not exist
Date
Msg-id CAG1ps1wgMGxA4ZMNRDzKpiFmzXoOrTcyNSG5ujL1h8ozaVt4qA@mail.gmail.com
Whole thread Raw
In response to database "cdf_100_1313" does not exist  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-general
Tree view
Hi Rob,

Please find the out put.
     
   Name         |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
----------------------+----------+----------+-------------+-------------+-----------------------
 CDF_10_11          | cpuser   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | cpuser=CTc/cpuser
 CDF_History  | cpuser   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | cpuser=CTc/cpuser
 CDF_100_1313         | cpuser   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | cpuser=CTc/cpuser

On Mon, Sep 9, 2019 at 6:58 PM Rob Sargent <robjsargent@gmail.com> wrote:


On Sep 9, 2019, at 7:16 AM, nikhil raj <nikhilraj474@gmail.com> wrote:

Hi Dan,

Still facing the same issue.

/usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d $DBLIST -c "GRANT CONNECT ON DATABASE $DBLIST TO cpupdate"
ERROR:  database "cdf_100_1313" does not exist


Can we see the output of psql’s \l ?

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: database "cdf_100_1313" does not exist
Next
From: Tom Lane
Date:
Subject: Re: Permissions on postgresql.conf, psql and patroni