Re: pg_dump issue with renamed system schemas - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump issue with renamed system schemas
Date
Msg-id 32073.1586550405@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump issue with renamed system schemas  ("Bossart, Nathan" <bossartn@amazon.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: spin_delay() for ARM
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] make async slave to wait for lsn to be replayed