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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
Date: 2024-06-01 13:53:05
Message-ID: CANzqJaBgPmXsF4JKiTaOAW_y2+s0D=mHDzEPi1kZ7k2jgccL2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 31, 2024 at 1:25 PM Alanoly Andrews <alanolya(at)invera(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2024-06-01 16:02:53 Proposing a PostgreSQL Independent Professionals Network
Previous Message Adrian Klaver 2024-05-31 21:57:04 Re: Issue with PostgreSQL Installer on Windows and Special Characters in the superuser password