dumping database privileges broken in 9.6

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема dumping database privileges broken in 9.6
Дата
Msg-id 9f25cb66-df67-8d81-ed6a-d18692a03410@2ndquadrant.com
обсуждение исходный текст
Ответы Re: dumping database privileges broken in 9.6  (Robert Haas <robertmhaas@gmail.com>)
Re: dumping database privileges broken in 9.6  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Do this:

CREATE DATABASE test1;
REVOKE CONNECT ON DATABASE test1 FROM PUBLIC;

Run pg_dumpall.

In 9.5, this produces

CREATE DATABASE test1 WITH TEMPLATE = template0 OWNER = peter;
REVOKE ALL ON DATABASE test1 FROM PUBLIC;
REVOKE ALL ON DATABASE test1 FROM peter;
GRANT ALL ON DATABASE test1 TO peter;
GRANT TEMPORARY ON DATABASE test1 TO PUBLIC;

In 9.6, this produces only

CREATE DATABASE test1 WITH TEMPLATE = template0 OWNER = peter;
GRANT TEMPORARY ON DATABASE test1 TO PUBLIC;
GRANT ALL ON DATABASE test1 TO peter;

Note that the REVOKE statements are missing.  This does not correctly 
recreate the original state.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: parallel workers and client encoding
Следующее
От: M Enrique
Дата:
Сообщение: Re: Gin index on array of uuid