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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Дата
Msg-id CANzqJaBefppMx=O6yHEd3osx+5obhWtt31cV8GXP2Kz+4iuvWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)  (Greg Sabino Mullane <htamfids@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, Oct 24, 2025 at 8:59 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
On Thu, Oct 23, 2025 at 10:51 AM Bala M <krishna.pgdba@gmail.com> wrote:
Any advice, recommendations, or shared experiences from others who have performed similar migrations would be greatly appreciated.

Some related advice: put some system in place to make sure you are always running the latest revision in whatever major version you end up. See:


In particular, note this part:

The community considers performing minor upgrades to be less risky than continuing to run an old minor version.

Not only that, but applying minor version update RPMs is fast.
Last weekend, this took 12 seconds to run:
alias suip='sudo -iupostgres'
suip pg_ctl stop -mfast -wt9999 \
    && sudo yum install -y Pg17.6_RHEL8/*rpm \
    && suip pg_ctl start -wt9999 \
    && psql -Xc "select version()"

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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