Re: pg_upgrade fails with non-standard ACL

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_upgrade fails with non-standard ACL
Дата
Msg-id 20190926200400.GA16366@momjian.us
обсуждение исходный текст
Ответ на Re: pg_upgrade fails with non-standard ACL  (Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>)
Ответы Re: pg_upgrade fails with non-standard ACL  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Sep 11, 2019 at 06:25:38PM -0300, Álvaro Herrera wrote:
> 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.

Well, right now, pg_upgrade --check succeeds, but the upgrade fails.  I
am proposing, at a minimum, that pg_upgrade --check fails in such cases,
with a clear error message about how to fix it.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Online checksums patch - once again
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_upgrade fails with non-standard ACL