NULL pg_database.datacl - Mailing list pgsql-general

From Dominique Devienne
Subject NULL pg_database.datacl
Date
Msg-id CAFCRh-83C18PKA7b=NNcxLF1FhBksot2v34ve0hR4ohrBAyL-w@mail.gmail.com
Whole thread Raw
Responses Re: NULL pg_database.datacl  (Erik Wienhold <ewie@ewie.name>)
List pgsql-general
Hi. I'm surprised, I thought ACLs would never be empty for a database.
Does that mean nobody can connect to this database?
I guess SUPERUSER and/or its datDBA can?
What does a NULL AclItem[] mean exactly?
(BTW, datallowconn is true)

Thanks, --DD

ddb=> select datname, datdba::regrole::text from pg_database where datacl is null;
 datname | datdba
---------+--------
 qadb    | qauser
(1 row)

PS: Was also surprised with  #42883: ERROR:  no binary output function available for type aclitem
  Thankfully datacl::text[] works fine in binary mode.

pgsql-general by date:

Previous
From: abdulsayeed24@gmail.com
Date:
Subject: Re[2]: Getting error while upgrading postgres from version 12 to 13
Next
From: Dávid Suchan
Date:
Subject: Re: pg_upgrade Only the install user can be defined in the new cluster