Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
Date
Msg-id CANzqJaBgPmXsF4JKiTaOAW_y2+s0D=mHDzEPi1kZ7k2jgccL2g@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound  (Alanoly Andrews <alanolya@invera.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Issue with PostgreSQL Installer on Windows and Special Characters in the superuser password
Next
From: Chris Travers
Date:
Subject: Proposing a PostgreSQL Independent Professionals Network