"Access privileges" is missing after pg_dumpall - Mailing list pgsql-hackers

From Prabhat Sahu
Subject "Access privileges" is missing after pg_dumpall
Date
Msg-id CANEvxPoHZ8324QsWfQGTaDacP-7cmm3JG8B-tLK+KMpYhK=U7w@mail.gmail.com
Whole thread Raw
Responses Re: "Access privileges" is missing after pg_dumpall
Re: "Access privileges" is missing after pg_dumpall
List pgsql-hackers
Hi,

I have taken pg_dumpall in pg-master and after restoring the dump I am not able to see the "Access privileges" as below:
Same is reproducible in back branches as well, is this fine ?


CREATE ROLE user1 PASSWORD 'user1' SUPERUSER LOGIN;
CREATE DATABASE db1 OWNER=user1;
GRANT ALL ON DATABASE db1 TO user1;

postgres=# \l+ db1
                                             List of databases
 Name | Owner | Encoding |  Collate      |   Ctype        | Access privileges   |  Size       | Tablespace | Description 
------+-------+----------+------------+------------+-------------------+---------+------------+-------------
 db1    | user1   | UTF8       | en_US.utf8 | en_US.utf8 | =Tc/user1             +| 7621 kB | pg_default  | 
           |             |                 |                    |                    | user1=CTc/user1    |               |                    | 
(1 row)

postgres=# SELECT datname as "Relation", datacl as "Access permissions" FROM pg_database WHERE datname = 'db1';
 Relation |     Access permissions      
----------+-----------------------------
 db1      | {=Tc/user1,user1=CTc/user1}
(1 row)


-- pg_dumpall 
./pg_dumpall > /tmp/dumpall.sql

-- Restore 
./psql -a -f /tmp/dumpall.sql


postgres=# \l+ db1
                                             List of databases
 Name | Owner | Encoding |  Collate       |   Ctype       | Access privileges |  Size      | Tablespace | Description 
------+-------+----------+------------+------------+-------------------+---------+------------+-------------
 db1    | user1   | UTF8       | en_US.utf8 | en_US.utf8 |                              | 7699 kB | pg_default | 
(1 row)

postgres=# SELECT datname as "Relation", datacl as "Access permissions" FROM pg_database WHERE datname = 'db1';
 Relation | Access permissions 
----------+--------------------
 db1      | 
(1 row)

--

With Regards,

Prabhat Kumar Sahu
Skype ID: prabhat.sahu1984
EnterpriseDB Corporation

The Postgres Database Company

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Regarding the correct and best way to fetching a tablename incontrib module
Next
From: "Ideriha, Takeshi"
Date:
Subject: Global shared meta cache