Bruce Momjian <br...@momjian.us> writes: > On Sat, Mar 20, 2021 at 11:23:19AM -0400, Tom Lane wrote: >> Of course, that just reduces the memory consumption on the client >> side; it does nothing for the locks. Can we get away with releasing the >> lock immediately after doing an ALTER OWNER or GRANT/REVOKE on a blob?
> Well, in pg_upgrade mode you can, since there are no other cluster > users, but you might be asking for general pg_dump usage. Yeah, this problem doesn't only affect pg_upgrade scenarios, so it'd really be better to find a way that isn't dependent on binary-upgrade mode. regards, tom lane