Re: ltree_gist indexes broken after pg_upgrade from 12 to 13

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: ltree_gist indexes broken after pg_upgrade from 12 to 13
Дата
Msg-id 20220307013202.3vldnfbftn4bqzpv@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Victor Yegorov <vyegorov@gmail.com>)
Список pgsql-hackers
Hi,

On 2022-03-07 01:12:07 +0200, Victor Yegorov wrote:
> пн, 7 мар. 2022 г. в 00:34, Andres Freund <andres@anarazel.de>:
> 
> > One thing that's likely worth doing as part of the cross version upgrade
> > test,
> > even if it wouldn't even help in this case, is to run amcheck post
> > upgrade. Just dumping data isn't going to touch indices at all.
> >
> > A sequence of
> >   pg_upgrade; amcheck; upgrade all extensions; amcheck;
> > would make sense.
> >
> 
> Is it possible to amcheck gist indexes?..

No. That was what I was alluding to with "even if it wouldn't even help in
this case".

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Time to drop plpython2?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Comment typo in CheckCmdReplicaIdentity