"Bossart, Nathan" <bossa...@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-e12f0661d...@postgrespro.ru AFAICT we didn't think we'd found a satisfactory solution yet. regards, tom lane