Re: pg_dump needs SELECT privileges on irrelevant extension table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jacob Champion <champion(dot)p(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Akshat Jaimini <destrex271(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump needs SELECT privileges on irrelevant extension table
Date: 2023-10-17 21:11:16
Message-ID: 2984517.1697577076@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

I wrote:
> Why are we marking extension member objects as being subject to SECLABEL
> or POLICY dumping? As the comment notes, that isn't really sensible
> unless what we are dumping is a delta from the extension's initial
> assignments. But we have no infrastructure for that, and none seems
> likely to appear in the near future.

Here's a quick patch that does it that way. The test changes
are identical to Jacob's v3-0001.

regards, tom lane

Attachment Content-Type Size
v4-0001-dont-try-to-dump-extension-RLS-policies.patch text/x-diff 5.1 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2023-10-18 01:22:14 Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss
Previous Message Tom Lane 2023-10-17 20:12:52 Re: pg_dump needs SELECT privileges on irrelevant extension table

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2023-10-17 21:17:46 Re: stopgap fix for signal handling during restore_command
Previous Message Tom Lane 2023-10-17 21:07:46 Re: run pgindent on a regular basis / scripted manner