Re: pg_upgrade fails with non-standard ACL

On 2019-Aug-21, Bruce Momjian wrote:

> > 1) How exactly should we report this incompatibility to a user?
> > I think it's fine to leave the warnings and also write some hint for the
> > user by analogy with other checks.
> > "Reset ACL on the problem functions to default in the old cluster to
> > continue"
>
> Yes, I think it is good to at least throw an error during --check so
> they don't have to find out during a live upgrade.  Odds are it will
> require manual repair.

I'm not sure what you're proposing here ... are you saying that the user
would have to modify the source cluster before pg_upgrade accepts to
run?  That sounds pretty catastrophic.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services