Re: locking [user] catalog tables vs 2pc vs logical rep - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: locking [user] catalog tables vs 2pc vs logical rep
Date
Msg-id YKszkBugv7heub1G@paquier.xyz
Whole thread Raw
List pgsql-hackers
On Mon, Feb 22, 2021 at 02:28:47PM -0800, Andres Freund wrote:
> Perhaps all that we need to do is to disallow 2PC prepare if [user]
> catalog tables have been locked exclusively? Similar to how we're
> disallowing preparing tables with temp table access.

At least for anything involving critical relations that get loaded at
startup?  It seems to me that if we can avoid users to get them
completely locked out even if they run the operation on an object
they own, that would be better than requiring tweaks involving
pg_resetwal or equal to rip of the 2PC transaction from existence.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Re: Parallel scan with SubTransGetTopmostTransaction assert coredump
Next
From: Dilip Kumar
Date:
Subject: Re: Race condition in recovery?