Re: pg_dump issue with renamed system schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump issue with renamed system schemas
Дата
Msg-id 32073.1586550405@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump issue with renamed system schemas  ("Bossart, Nathan" <bossartn@amazon.com>)
Список pgsql-hackers
"Bossart, Nathan" <bossartn@amazon.com> writes:
> I think I've found a small bug in pg_dump that could cause some schema
> privileges to be missed.  In short, if you've renamed a schema that
> has an entry in pg_init_privs, pg_dump will skip dumping the initial
> ACL for the schema.  This results in missing privileges on restore.

This seems like a special case of the issue discussed in

https://www.postgresql.org/message-id/flat/f85991ad-bbd4-ad57-fde4-e12f0661dbf0@postgrespro.ru

AFAICT we didn't think we'd found a satisfactory solution yet.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: spin_delay() for ARM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] make async slave to wait for lsn to be replayed