Or perhaps we should still also patch pg_dump to ignore the aclentries which refer to roles that do not exist in the database ?
On Thu, Jun 20, 2024 at 7:41 PM Hannu Krosing <han...@google.com> wrote: > > Then maybe we should put a query / function in the release notes to > clean up the existing mess. > > Thinking of it we should do it anyway, as the patch only prevents new > messiness from happening and does not fix existing issues. > > I could share a query to update the pg_init_privs with non-existent > role to replace it with the owner of the object if we figure out a > correct place to publish it. > > --- > Hannu > > > > > On Thu, Jun 20, 2024 at 5:35 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > > > > Hannu Krosing <han...@google.com> writes: > > > Is there anything that could be back-patched with reasonable effort ? > > > > Afraid not. The whole thing is dependent on pg_shdepend entries > > that won't exist in older branches. > > > > regards, tom lane
