Message-ID: <40c1e76334f2baa747334c8fc513d12b8cb297bf.camel@j-davis.com>
Subject: Re: pgsql: Trial fix for old cross-version upgrades.
From: Jeff Davis <pgsql@j-davis.com>
To: Jeff Davis <jdavis@postgresql.org>, pgsql-committers@lists.postgresql.org
Date: Fri, 21 Feb 2025 16:57:43 -0800
In-Reply-To: <003dc9936317ab987faa0242f8e33e1cd2fcaf57.camel@j-davis.com>
References: <E1tlBJt-000LUO-16@gemulon.postgresql.org>
	 <003dc9936317ab987faa0242f8e33e1cd2fcaf57.camel@j-davis.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu2 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/40c1e76334f2baa747334c8fc513d12b8cb297bf.camel%40j-davis.com>
Precedence: bulk

On Thu, 2025-02-20 at 13:17 -0800, Jeff Davis wrote:
> On Thu, 2025-02-20 at 18:30 +0000, Jeff Davis wrote:
> > Trial fix for old cross-version upgrades.
>=20
> That fixed one problem, but there are other problems with 9.2
> upgrades.

The version that I committed had the following change to
002_pg_upgrade.pl:

  # Stabilize stats before pg_dumpall.
  $oldnode->append_conf('postgresql.conf', 'autovacuum =3D off');
  $oldnode->restart;

  ...

  $newnode->append_conf('postgresql.conf', 'autovacuum =3D off');

I think we need a similar change in the buildfarm client's
TestUpgradeXversion.pm? Is -hackers the right place to discuss that?

Regards,
	Jeff Davis