From: | Dan Livingston <danlivingstone(at)gmail(dot)com> |
---|---|
To: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
Cc: | 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:08:35 |
Message-ID: | CAG9w53r3U8X5R2xLTZ1voQUyNm9SgSJerVkd=QDzYTM0HHa93g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think you need to add parens around the command to populate DBLIST and
remove the quotes in the GRANT command.
In bash this works for me:
DBLIST=$(/usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d postgres -q
-t -c "SELECT datname from pg_database where datname in ('tempdb')")
/usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d $DBLIST -c "GRANT
CONNECT ON DATABASE $DBLIST TO dbuser1"
On Mon, Sep 9, 2019 at 5:58 AM nikhil raj <nikhilraj474(at)gmail(dot)com> wrote:
> Hi Karsten,
>
> yup you are right can you help in i tried by removing quotion and also
> adding extra having same issue.
>
> On Mon, Sep 9, 2019 at 5:25 PM Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
> wrote:
>
>> On Mon, Sep 09, 2019 at 05:16:20PM +0530, nikhil raj wrote:
>>
>> >
>> > 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
>>
>> Likely a quoting issue.
>>
>> Karsten Hilbert
>> --
>> GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
>>
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | nikhil raj | 2019-09-09 13:16:49 | Re: database "cdf_100_1313" does not exist |
Previous Message | Jim Finnerty | 2019-09-09 12:42:41 | Re: Whan is it safe to mark a function PARALLEL SAFE? |