Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
Дата
Msg-id CANzqJaBgPmXsF4JKiTaOAW_y2+s0D=mHDzEPi1kZ7k2jgccL2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound  (Alanoly Andrews <alanolya@invera.com>)
Список pgsql-general
Дерево обсуждения
On Fri, May 31, 2024 at 1:25 PM Alanoly Andrews <alanolya@invera.com> wrote:
Yes, and I know that upgrading the Postgres version is the stock answer for situations like this. The upgrade is in the works.

Patching was the solution.  It takes five minutes.
Here's how I did it (since our RHEL systems are blocked from the Internet, and I had to manually d/l the relevant RPMs):
$ sudo -iu postgres pg_ctl stop -wt9999 -mfast
$ sudo yum install PG96.24_RHEL6/*rpm
$ sudo -iu postgres pg_ctl start -wt9999

You'll have a bit of effort finding the PG10 repository, since it's EOL, but it can be found.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Issue with PostgreSQL Installer on Windows and Special Characters in the superuser password
Следующее
От: Chris Travers
Дата:
Сообщение: Proposing a PostgreSQL Independent Professionals Network