Re: REINDEX and shared catalogs

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: REINDEX and shared catalogs
Date: 2018-08-08 18:28:20
Message-ID: 20180808182820.kbaglejfgzwothsq@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2018-Aug-05, Michael Paquier wrote:

> Attached is a set of patches I proposed on the original thread, which
> skips shared catalogs if the user running REINDEX is not an owner of
> it. This is a behavior change, and as I have a hard time believing that
> anybody can take advantage of the current situation, I would like also
> to see this stuff back-patched, as anybody doing shared hosting of
> Postgres is most likely fixing the hole one way or another. However, I
> am sure as well that many folks here would not like that.

I agree that it would be good to have it fixed in released versions, but
I also agree that such a change could cause trouble in production for
some. Is the "no backpatch" idea that you will push this to both pg11
and master? That would get my vote.

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-08-08 18:39:00 Re: REINDEX and shared catalogs
Previous Message Peter Geoghegan 2018-08-08 17:27:59 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid