Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKypT-0001mq-Ih for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Mar 2021 07:36:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKypR-0001uN-Iy for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Mar 2021 07:36:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKypR-0001t0-BZ for pgsql-hackers@lists.postgresql.org; Sat, 13 Mar 2021 07:36:53 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKypP-0003iB-Oj for pgsql-hackers@postgresql.org; Sat, 13 Mar 2021 07:36:53 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 12D7ad2e2593530; Sat, 13 Mar 2021 02:36:39 -0500 From: Tom Lane To: Noah Misch cc: Mark Dilger , Robert Haas , Peter Geoghegan , Thomas Munro , "Andrey M. Borodin" , Stephen Frost , Michael Paquier , Amul Sul , Dilip Kumar , Andres Freund , PostgreSQL-development Subject: Re: pg_amcheck contrib application In-reply-to: <20210313071913.GA3112164@rfd.leadboat.com> References: <2574324.1615611372@sss.pgh.pa.us> <2588078.1615613250@sss.pgh.pa.us> <2589781.1615615635@sss.pgh.pa.us> <20210313061655.GC3099026@rfd.leadboat.com> <6BBDE6C1-3F40-4009-896D-9CA9D87BEC9A@enterprisedb.com> <2590503.1615616574@sss.pgh.pa.us> <2591070.1615617371@sss.pgh.pa.us> <20210313071913.GA3112164@rfd.leadboat.com> Comments: In-reply-to Noah Misch message dated "Fri, 12 Mar 2021 23:19:13 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2593528.1615620999.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Sat, 13 Mar 2021 02:36:39 -0500 Message-ID: <2593529.1615620999@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Noah Misch writes: > On Sat, Mar 13, 2021 at 01:36:11AM -0500, Tom Lane wrote: >> I don't mind updating the perl installations on prairiedog and gaur, >> but Noah might have some difficulty with his AIX flotilla, as I believe >> he's not sysadmin there. > The AIX animals have Perl v5.28.1. hoverfly, in particular, got a big u= pdate > package less than a month ago. Hence, I doubt it's a question of applyi= ng > routine updates. The puzzle would be to either (a) compile a 32-bit Per= l that > handles unpack('q') or (b) try a PostgreSQL configuration like "./config= ure > ... PROVE=3D'perl64 /usr/bin/prove --'" to run the TAP suites under perl= 64. > (For hoverfly, it's enough to run "prove" under $PERL. mandrill, howeve= r, > needs a 32-bit $PERL for plperl, regardless of what it needs for "prove"= .) > Future AIX packagers would face doing the same. Yeah. prairiedog and gaur are both frankenstein systems: some of the software components are years newer than the underlying OS. So I don't mind changing them further; in the end they're both in the buildfarm for reasons of hardware diversity, not because they represent platforms anyone would run production PG on. On the other hand, those AIX animals represent systems that are still considered production grade (no?), so we have to be willing to adapt to them not vice versa. > With v5-0001-pg_amcheck-continuing-to-fix-portability-problems.patch bei= ng so > self-contained, something like it is the way to go. I'm only concerned about whether the all-zero value causes any significant degradation in test quality. Probably Peter G. would have the most informed opinion about that. regards, tom lane