MIME-Version: 1.0
References: <YQBPR01MB10625A12760CAECAE647F415EABF32@YQBPR01MB10625.CANPRD01.PROD.OUTLOOK.COM>
 <4fbdd9760b329bccbdd62b6645d5977bee957e0d.camel@cybertec.at>
 <CAA-aLv5sNn4M5NwNFZy6d7mG1TrGJm-_6XGHPXX13OHObvUnaw@mail.gmail.com> <YQBPR01MB106258258B8372A1ED0DA0648ABFC2@YQBPR01MB10625.CANPRD01.PROD.OUTLOOK.COM>
In-Reply-To: <YQBPR01MB106258258B8372A1ED0DA0648ABFC2@YQBPR01MB10625.CANPRD01.PROD.OUTLOOK.COM>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 1 Jun 2024 09:53:05 -0400
Message-ID: <CANzqJaBgPmXsF4JKiTaOAW_y2+s0D=mHDzEPi1kZ7k2jgccL2g@mail.gmail.com>
Subject: Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no
 longer exist -- apparent wraparound
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000b487a0619d46cd0"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBgPmXsF4JKiTaOAW_y2%2Bs0D%3DmHDzEPi1kZ7k2jgccL2g%40mail.gmail.com>
Precedence: bulk

--0000000000000b487a0619d46cd0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, May 31, 2024 at 1:25=E2=80=AFPM Alanoly Andrews <alanolya@invera.co=
m> 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.

--0000000000000b487a0619d46cd0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, May 31, 2024 at 1:25=E2=80=AFPM A=
lanoly Andrews &lt;<a href=3D"mailto:alanolya@invera.com">alanolya@invera.c=
om</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex"><div class=3D"msg-8931760034602660695">


<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><span style=3D"fo=
nt-size:12pt">Yes, and I know that upgrading the Postgres version is the st=
ock answer for situations=C2=A0like this. The upgrade is in the works.</spa=
n></div></div></div></blockquote><div><br></div><div><b>Patching=C2=A0</b>w=
as the solution.=C2=A0 It takes <b>five minutes</b>.</div><div>Here&#39;s h=
ow I did it (since our RHEL systems are blocked from the Internet, and I ha=
d to manually d/l the relevant RPMs):</div><div>$ sudo -iu postgres pg_ctl =
stop -wt9999 -mfast</div><div>$ sudo yum install PG96.24_RHEL6/*rpm</div><d=
iv>$ sudo -iu postgres pg_ctl start -wt9999<br></div><div><br></div><div>Yo=
u&#39;ll have a bit of=C2=A0effort finding=C2=A0the PG10 repository, since =
it&#39;s EOL, but it can be found.</div><div><br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div class=3D"msg-8931760034602660695"><div d=
ir=3D"ltr"><div style=3D"font-size:8pt;font-family:Calibri,sans-serif">
</div>
</div>

</div></blockquote></div></div>

--0000000000000b487a0619d46cd0--