From: Tom Lane <tgl@sss.pgh.pa.us>
To: Noah Misch <noah@leadboat.com>
cc: Andres Freund <andres@anarazel.de>,
 Kirill Reshke <reshkekirill@gmail.com>,
        Alexander Lakhin <exclusion@gmail.com>, pgsql-hackers@postgresql.org,
        Robert Haas <robertmhaas@gmail.com>
Subject: Re: Test instability when pg_dump orders by OID
In-reply-to: <20250826005724.ed.nmisch@google.com>
References: <d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com>
 <CALdSSPhZyLua3Vz2Ug8VOASbhP41h-7784MT8s9_+90eE06Aaw@mail.gmail.com>
 <20250810163659.71.nmisch@google.com>
 <CALdSSPjDpzTAJsOwyuBy9Hxz7dmZyNTamQWBjEsKJD0KFcbphg@mail.gmail.com>
 <20250823052019.43.nmisch@google.com> <20250823144505.88.nmisch@google.com>
 <3th37rt7erqwk3rj63kozbbt2p2rxfg4inz54p77jvq7usojqu@vo2w2gdugz5w>
 <163245.1756050601@sss.pgh.pa.us> <20250824160816.06.nmisch@google.com>
 <zbtz2k4kxxxih7c52wbckkci257rw3ox3af3b5bv56ur3zu7hn@3qogpu6aq4aq>
 <20250826005724.ed.nmisch@google.com>
Comments: In-reply-to Noah Misch <noah@leadboat.com>
	message dated "Mon, 25 Aug 2025 17:57:24 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <971403.1756170372.1@sss.pgh.pa.us>
Date: Mon, 25 Aug 2025 21:06:12 -0400
Message-ID: <971404.1756170372@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/971404.1756170372%40sss.pgh.pa.us>
Precedence: bulk

Noah Misch <noah@leadboat.com> writes:
> On Mon, Aug 25, 2025 at 05:15:55PM -0400, Andres Freund wrote:
>> I think it's also about removing painful manual testing - and imo manually
>> running cross-version pg_upgrade tests is really rather painful.

> I make the buildfarm client drive it.

Yeah, same here.  I have a BF instance lying around that's configured
to do the cross-version pg_upgrade tests.  It's not registered with
the BF server, I just run it manually when I need to test that.

			regards, tom lane