From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
cc: Noah Misch <noah@leadboat.com>, 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: <3th37rt7erqwk3rj63kozbbt2p2rxfg4inz54p77jvq7usojqu@vo2w2gdugz5w>
References: 
 <CA+Tgmoa8FumzaUUSnjK0x=6_oXDXggQPpzgPfX-KE=PVrTyamg@mail.gmail.com>
 <20250725022740.30.nmisch@google.com>
 <CA+TgmoZXmAZmB9OZaXTiy-HG2_1d7UiYrFKXf17C_yLfPa5pQg@mail.gmail.com>
 <20250804000321.8b.nmisch@google.com>
 <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>
Comments: In-reply-to Andres Freund <andres@anarazel.de>
	message dated "Sun, 24 Aug 2025 11:31:51 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <163244.1756050601.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 24 Aug 2025 11:50:01 -0400
Message-ID: <163245.1756050601@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/163245.1756050601%40sss.pgh.pa.us>
Precedence: bulk

Andres Freund <andres@anarazel.de> writes:
> I wonder if it's worth adding support to CI to perform the cross-version
> upgrade test. It'd be pretty easy to install all pgdg apt postgres packa=
ges to
> the debian image, which then could be used as the source version...

I feel that that's the wrong tradeoff.  CI should be expected to be
fairly cheap, not to catch everything the buildfarm could catch.

			regards, tom lane