RE: pg_init_privs corruption. - Mailing list pgsql-hackers

From Floris Van Nee
Subject RE: pg_init_privs corruption.
Date
Msg-id c5ec75ee718e4b4bac8f8ace49c650ce@opammb0562.comp.optiver.com
Whole thread Raw
In response to Re: pg_init_privs corruption.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_init_privs corruption.
List pgsql-hackers
> Kirill Reshke <reshke@double.cloud> writes:
> > As you can see, after drop role there is invalid records in
> > pg_init_privs system relation. After this, pg_dump generate sql
> > statements, some of which are based on content of pg_init_privs, resulting
> in invalid dump.
>

This is as far as I can see the same case as what I reported a few years ago here:
https://www.postgresql.org/message-id/flat/1574068566573.13088%40Optiver.com#488bd647ce6f5d2c92764673a7c58289
There was a discussion with some options, but no fix back then.

-Floris




pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: Re: [PATCH] Add pretty-printed XML output option
Next
From: Andres Freund
Date:
Subject: Re: recovery modules