Re: database "cdf_100_1313" does not exist

From: nikhil raj <nikhilraj474(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: Dan Livingston <danlivingstone(at)gmail(dot)com>, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: database "cdf_100_1313" does not exist
Date: 2019-09-09 13:43:43
Message-ID: CAG1ps1wgMGxA4ZMNRDzKpiFmzXoOrTcyNSG5ujL1h8ozaVt4qA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com> wrote:

>
>
> On Sep 9, 2019, at 7:16 AM, nikhil raj <nikhilraj474(at)gmail(dot)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 ?
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-09-09 14:03:57 Re: Permissions on postgresql.conf, psql and patroni
Previous Message Rob Sargent 2019-09-09 13:28:29 Re: database "cdf_100_1313" does not exist