Re: Moving from RHEL6 to RHEL8

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: Moving from RHEL6 to RHEL8
Дата
Msg-id CAGnEboiTp0kR9=rycXM20YXn6Sb9t8=7fb7fsBO=pYPofprqiw@mail.gmail.com
обсуждение исходный текст
Ответ на Moving from RHEL6 to RHEL8  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin
пт, 4 мар. 2022 г. в 22:12, Ron <ronljohnsonjr@gmail.com>:
Can we "just" move the database LUNs (this is on a SAN, and the servers are
ESX VMs) from the old server to the new server, and then rebuild all indices
with text columns?

Pretty much yes. Though we do it slightly different:
- setup physical replica on the new host
- use amcheck for all btree indexes and add those that needs reindexing to the list
- add all non-btree indexes where we can find attributes with pg_collation.collname NOT IN ('C', 'POSIX') to the same list
- run reindexing in parallel via xargs to measure time required (replica should be re-created after this of course).


--
Victor Yegorov

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

Предыдущее
От: Ron
Дата:
Сообщение: Moving from RHEL6 to RHEL8
Следующее
От: Kishore Dahlstrom
Дата:
Сообщение: Re: Moving from RHEL6 to RHEL8