Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Дата
Msg-id CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com
обсуждение исходный текст
Ответ на Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)  (Bala M <krishna.pgdba@gmail.com>)
Ответы Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Список pgsql-general
On Wed, Oct 22, 2025 at 6:53 AM Bala M <krishna.pgdba@gmail.com> wrote:
  • PostgreSQL Version: 11.15


Ouch! Not only is the major version end of life, but that's not even the latest revision of 11. At this point, you should use logical replication to migrate from your v11 to a shiny new Postgres v18 on your RHEL9 box. As Chris pointed out, the indexes are a libc problem, but your bigger problem is being on v11.15. If you want to trade complexity for time, you could consider using pg_dump to do the upgrade instead of logical replication.


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

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