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 CAKFQuwZWQf--+Gj7Ld9x+XQ_Bsvj+OE0_A01jj6GhQ451H4ZGA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade does not upgrade pg_stat_statements properly  (Dave Cramer <davecramer@gmail.com>)
Список pgsql-hackers
On Wed, Jul 14, 2021 at 12:21 PM Dave Cramer <davecramer@gmail.com> wrote:

On Wed, 14 Jul 2021 at 15:09, David G. Johnston <david.g.johnston@gmail.com> wrote:

Something like, "... because the installed extensions will be copied from the old cluster during the upgrade."

This is still rather opaque. Without intimate knowledge of what changes have occurred in each extension I have installed; how would I know what I have to fix after the upgrade. 

The point of this behavior is that you don't have to fix anything after an upgrade - so long as your current extension version works on the new cluster.  If you are upgrading in such a way that the current extension and new cluster are not compatible you need to not do that.  Upgrade instead to a lesser version where they are compatible.  Then upgrade your extension to its newer version, changing any required user code that such an upgrade requires, then upgrade the server again.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Hooks at XactCommand level
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Replacing pg_depend PIN entries with a fixed range check