database "cdf_100_1313" does not exist

From: nikhil raj <nikhilraj474(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: database "cdf_100_1313" does not exist
Date: 2019-09-09 11:46:20
Message-ID: CAG1ps1w3_Ewc7EaPDWWpm1hae1v4DQsgdDyBFPtE=cBQ66k_kA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

The DB is already there and getting the error of the DB does not exist
where I execute it via shell.
DBLIST=/usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d postgres -q
-t -c "SELECT datname from pg_database where datname in
('CDF_100_1313')"/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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2019-09-09 11:54:54 Re: database "cdf_100_1313" does not exist
Previous Message Daniel Verite 2019-09-09 11:29:38 Re: Permissions on postgresql.conf, psql and patroni