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 1nZxND-00069K-CS for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 16:10:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZxNC-0002y1-A6 for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 16:10:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nZxNA-0002xn-FH for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 16:10:10 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nZxN7-0004rJ-60 for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 16:10:07 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 0890F5C0236; Thu, 31 Mar 2022 12:10:04 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Thu, 31 Mar 2022 12:10:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=5DGuNml+KXUd+LroNOc4c9SNkusMLzgB/KOkY/ QkzQY=; b=0lMEr5uYxbSUAm1jgEHZnXVi3IGP2dsPxtjhGpsBOf9jrio6aWalgN G7vFg/gpuQUPfU+x0kyjJeCmScjv1Rpy24N1eZKvdRr82RKZGAAbDqpyJfP+5NDH BuQmhWf6ieaT+DaVmSVe3iOQ0kN+emMYXMY1Lig7w01/OEiVScZbna/tG8NamkFj EySqNsr784rBz1avtNGlK/vjxdWLZyiBTDuRhUUl4XVITOl7mKUE88WCbb4FsNSf /euIPPLfWBpUG6ZSqZ1RzsLyuHj/VzYjEiOi8GWbPPhJmFeMzVqWDWbU/YcbZ+wa ir+B6eMaBlzOOm9IwMMvpJY6mAqo+ViA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=5DGuNml+KXUd+LroN Oc4c9SNkusMLzgB/KOkY/QkzQY=; b=kbpYODeax5+E+paFQaCl3Zv/aJh8qOhMA D8lmJgMnEXOClPErQgKenxbS1iNOtvrQzLkJdulyK6jjt3W1UG2iz6dDj+6f75Rd I0DxBj5G/YrB/w+XuSK2jhdOZB8NVG+/3iiIv1Vt5A/KCZEahS/ceWfWIvx1+nan DsscD1QLNbG/Avl4sx6QktJmmmwtiEpljWYffsBOtqwjTIZca5M5uZv06HYzK/JC 1S5Eudj8QVGAItq+3Fx97LX2m/7QwctHz0pAirIzkvBz4sq5hnrYiUaIiu4nFZUt WFTZYSvxNd4BkTsR9amBHfs1l5sZqBRhd/A5U5ZR1tKmh/mI2qBlw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudeigedgleejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 31 Mar 2022 12:10:03 -0400 (EDT) Date: Thu, 31 Mar 2022 09:10:02 -0700 From: Andres Freund To: Tom Lane Cc: Robert Haas , Andrew Dunstan , Nathan Bossart , Thomas Munro , PostgreSQL Hackers , Magnus Hagander Subject: Re: pgsql: Add 'basebackup_to_shell' contrib module. Message-ID: <20220331161002.4nerjsam7ugp56fw@alap3.anarazel.de> References: <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> <639823.1648740735@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <639823.1648740735@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-03-31 11:32:15 -0400, Tom Lane wrote: > Robert Haas writes: > * 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. Seems like Cluster.pm should have a helper for creating roles, which then would use --create-role internally. So there's at least something to find when looking through Cluster.pm... Greetings, Andres Freund