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 1nZwmf-0004Ad-EF for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 15:32:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZwme-0004HC-B3 for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 15:32:24 +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 1nZwme-0004H1-27 for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 15:32:24 +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 1nZwmb-0006Qj-Dx for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 15:32:23 +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 22VFWFvi639824; Thu, 31 Mar 2022 11:32:15 -0400 From: Tom Lane To: Robert Haas cc: Andrew Dunstan , Nathan Bossart , Andres Freund , Thomas Munro , PostgreSQL Hackers , Magnus Hagander Subject: Re: pgsql: Add 'basebackup_to_shell' contrib module. In-reply-to: References: <20220329222504.aylyimyub6igsvpy@alap3.anarazel.de> <684ed71e-0876-60c0-8e44-066ba702f0a6@dunslane.net> <20220330163024.fsbpbxwxh5oo2ktx@alap3.anarazel.de> <20220330165450.3lruwky7eveddsvq@alap3.anarazel.de> <285252.1648671723@sss.pgh.pa.us> <20220330223531.GA134543@nathanxps13> <472639.1648684865@sss.pgh.pa.us> <485495.1648692468@sss.pgh.pa.us> Comments: In-reply-to Robert Haas message dated "Thu, 31 Mar 2022 11:12:07 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <639822.1648740735.1@sss.pgh.pa.us> Date: Thu, 31 Mar 2022 11:32:15 -0400 Message-ID: <639823.1648740735@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robert Haas writes: > On Thu, Mar 31, 2022 at 10:52 AM Andrew Dunstan wrote: >> We should probably fix the test though, so it doesn't require Unix >> sockets. It should be possible, although I haven't looked yet to see how. > Our mutual colleague Neha Sharma pointed out this email message to me: > http://postgr.es/m/106926.1643842376@sss.pgh.pa.us Ah, right. > I actually don't understand why using pg_regress --auth-extra would > fix it, or what that option does, or why we're even running pg_regress > at all in PostgreSQL::Test::Cluster::init. I think it might be to fix > this exact issue, but there's no SGML documentation for pg_regress, I'm not volunteering to fix that, but this comment in pg_regress.c is probably adequately illuminating: * Rewrite pg_hba.conf and pg_ident.conf to use SSPI authentication. Permit * the current OS user to authenticate as the bootstrap superuser and as any * user named in a --create-role option. This script is creating users manually rather than letting the TAP infrastructure do it, which is an antipattern. regards, tom lane