From: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | "Access privileges" is missing after pg_dumpall |
Date: | 2018-06-26 06:42:58 |
Message-ID: | CANEvxPoHZ8324QsWfQGTaDacP-7cmm3JG8B-tLK+KMpYhK=U7w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ideriha, Takeshi | 2018-06-26 06:48:28 | Global shared meta cache |
Previous Message | Michael Paquier | 2018-06-26 06:22:40 | Re: Regarding the correct and best way to fetching a tablename in contrib module |