"Access privileges" is missing after pg_dumpall

Поиск
Список
Период
Сортировка
От Prabhat Sahu
Тема "Access privileges" is missing after pg_dumpall
Дата
Msg-id CANEvxPoHZ8324QsWfQGTaDacP-7cmm3JG8B-tLK+KMpYhK=U7w@mail.gmail.com
обсуждение исходный текст
Ответы Re: "Access privileges" is missing after pg_dumpall  (Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>)
Re: "Access privileges" is missing after pg_dumpall  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Regarding the correct and best way to fetching a tablename incontrib module
Следующее
От: "Ideriha, Takeshi"
Дата:
Сообщение: Global shared meta cache