Re: pg_upgrade does not upgrade pg_stat_statements properly

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pg_upgrade does not upgrade pg_stat_statements properly
Дата
Msg-id CAKFQuwbsRZCpnfX49krb_Ke3WnNXCRFt3JgOvQUM8PXAu7TFDw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade does not upgrade pg_stat_statements properly  (Dave Cramer <davecramer@gmail.com>)
Ответы Re: pg_upgrade does not upgrade pg_stat_statements properly
Re: pg_upgrade does not upgrade pg_stat_statements properly
Список pgsql-hackers
Дерево обсуждения
On Thu, Jul 15, 2021 at 9:16 AM Dave Cramer <davecramer@gmail.com> wrote:
Eh, and
  pg_upgrade [other switches] --upgrade-extensions
sounds good too ...

Ultimately I believe this is the solution, however we still need to teach extensions how to upgrade themselves or emit a message saying they can't, or even ignore if it truly is a NOP.


If it's opt-in and simple I don't really care but I doubt I would use it as personally I'd rather the upgrade not touch my application at all (to the extent possible) and just basically promise that I'll get a reliable upgrade.  Then I'll go ahead and ensure I have the backups of the new version and that my application works correctly, then just run the "ALTER EXTENSION" myself.  But anything that will solve pain points for same-PostgreSQL-version extension upgrading is great.

I would say that it probably should be "--upgrade-extension=aaa --upgrade_extension=bbb" though if we are going to the effort to offer something.

David J.


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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: pg_upgrade does not upgrade pg_stat_statements properly
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: unnesting multirange data types