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 1neX8j-0002jT-Rk for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Apr 2022 07:10:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1neX8i-0001Bz-QV for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Apr 2022 07:10:08 +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 1neX8i-0001Bq-Gh for pgsql-hackers@lists.postgresql.org; Wed, 13 Apr 2022 07:10:08 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1neX8h-0005li-Cl for pgsql-hackers@postgresql.org; Wed, 13 Apr 2022 07:10:08 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 031545C030D; Wed, 13 Apr 2022 03:10:06 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 13 Apr 2022 03:10:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; 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; t=1649833805; x=1649920205; bh=DIaq0qQXt+ Zib7BADbH6edz9YZqcjzXNkgoU8933QNo=; b=of+uFjM+Yba5rj9TvH/cF3Zwzm 6nxXXEa55GYlg3VvB5/wQic1N2v8VaDv/MMGPftWSRjLp/FP/KCilX88UX+oGWSl 2NrJs8n5dHZNCEFqvUQlCSKUY4n9kURtlJYPQxHt5PGtW4y9Olv+caCZ1V+Qaws9 0G+DQL2NCgTG15042S0btgUpR2bwWChs8UzmgYbsUxp3GYRN3ULVOob73cfW7HVx 3R8IGoSlbHkmjN/PwLScj7tWJccb2SNhc/VNq7c3v66j+cda9Etr3zzmCrlA7Mo9 kDbagDeL4xuSQ5pXZw0g0412weJQEktVGH9L+vl9j92ZLkQ/AfRhpMvVq7Yg== 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=fm1; t=1649833805; x= 1649920205; bh=DIaq0qQXt+Zib7BADbH6edz9YZqcjzXNkgoU8933QNo=; b=I NVwkOLctSGXvWybW4j3j800OwX2LIJr027HAbAVRzrXK3HhyLdCj9L3yMkcXZtiG rTZlCVXV8QGnD3nnBCAZBV2HFoIJTAGjwnaW6hcCeapqk551Aso27/qlOTNyfRUC ajbxUdJ2/8w74WN/sfaRSrzayd0/EDZzDS8RIv3ZJI3M0TlzLMI+1XAxGNGWmIew 5YvlF1GoqOZxEzZyZWgrtLLMB7yvvG0V7+1iZH37TokJ9oHhKqo8QDucKvK0ZsHP prv9P2elIUKl9vUzOTpbiifbp7pBeWiTonbK+Vixy/SDOFYFh0lecRpewVAvocC0 1L9HP6/OqdbYTUaCefs7Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudekledgudduiecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepff fhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefh necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 13 Apr 2022 03:10:03 -0400 (EDT) Date: Wed, 13 Apr 2022 16:10:01 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: Shinya11.Kato@oss.nttdata.com, pgsql-hackers@postgresql.org Subject: Re: Add --{no-,}bypassrls flags to createuser Message-ID: References: <69a9851035cf0f0477bcc5d742b031a3@oss.nttdata.com> <20220413.154625.2001259434473326066.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lYIWe8KqJH/Qj48d" Content-Disposition: inline In-Reply-To: <20220413.154625.2001259434473326066.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --lYIWe8KqJH/Qj48d Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Apr 13, 2022 at 03:46:25PM +0900, Kyotaro Horiguchi wrote: > It is sensible to rig createuser command with full capability of > CREATE ROLE is reasonable. >=20 > Only --replication is added by commit 9b8aff8c19 (2010) since > 8ae0d476a9 (2005). BYPASSRLS and NOBYPASSRLS were introduced by > 491c029dbc (2014) but it seems to have forgotten to add the > corresponding createuser options. >=20 > By a quick search, found a few other CREATE ROLE optinos that are not > supported by createuser. My question is: is BYPASSRLS common enough to justify having a switch to createuser? As the development cycle of 15 has just finished and that we are in feature freeze, you may want to hold on new patches for a bit. The next commit fest is planned for July. -- Michael --lYIWe8KqJH/Qj48d Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmJWd0kACgkQnvQgOdby QH37TQ/5AUVabaAqTppNViXTjoNNbXwMrj2xA+w9Hrkhaum0rmyM2gEI2RXGHLCB e8JhH3ftoux0nP8pam+UhjC/oWQzsn2pKJMervrYREneYa8GQEJQCsygLLsUjEqA V2ULbcU2+Kx8M6hPORhMBORyDbJlqCfqxcweFlaMkQvnCFM/rtS0OXuhv4OZLCTu AKmwiSChmvD4ZCPVxItR0a+uveAqFz23kyxkwwdaqv0ZO0T5Wquu9cWyYNOQjuMx RwF376KEVJe1u4UKZwJpxr/TVgCHRvgeL5Q2KopNUZiDE2jUVRe7z66A4PY/GCFR /arQqzvODnfmcxVjHZ7sPVZsqIToz0F8CVHfFey7LaIF8zsLkadb+yEMBYQZvTuG AqursM7qFwtTl5SGLPfMOFVrROhDRas0Dvo9pmJFwQMH8/T0IRpD0MRkfR7/uhw2 HXoa1QLl1LvmjLoC1E1AernjcPXcE5AahNoY7gmHmotwbnJwniAfuZGdWd733XJj N2EbsGiQSOfKGR+qQh9gtJcp7HDYO3Tvwxgv7Aa9SdmrjXdoPvpSDcL9wwhpCCUj FFyrXkvhSo56szQdShYnPY5dTjEpmvgXUi0loWmMwRu4BegQlw8i99gRbcvCVv6e YXJ+UsKb5F+qPRFjEwgTofuoQRGWhHRTa+yku4bu/N0mpCxZffI= =OGrU -----END PGP SIGNATURE----- --lYIWe8KqJH/Qj48d--