Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h78Ab-0004EK-Qy for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 00:36:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h78AZ-0003AT-Fc for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 00:36:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h78AZ-0003AL-4U for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 00:36:23 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h78AW-0004cX-LI for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 00:36:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 14DBD2491D; Thu, 21 Mar 2019 20:36:20 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 21 Mar 2019 20:36:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=CRzvnms1IZf59y9CzZqG4g/SW0+ 0WQ5eWWDKahk/GMU=; b=CeAQ+sP/z8oDDpDnYfl0iuihVBaKb9tY7UwJvIFq01X Y4Jl37FHC9sOIG0SCM4Lxh5pkDyODuy3xBdTUjcu13orIKE6hbPAuCGwSwyR7HAA 9rBRCHouRGaQzWEWJK9v2sJrFpfAImPvSdn5KXhOQGPrK6mzA53GvxSH5XsYiGth 7HAL/D6wEmQGwEsioACcaDZQkcO/oD6eBa0DmNbfjf3yyBESTLnKE/txbg2zQ1eQ F4US/XAlNobpd50/m/UH1ffPM11LKDv7xijehHl+lih8G/m2Ffu/8L0R3GMipJDO uFdh6Zp3NlIH7T2uQlACTVWdLGOA2Xy8k7luY+eO+Lw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=CRzvnm s1IZf59y9CzZqG4g/SW0+0WQ5eWWDKahk/GMU=; b=oaSOQR6KalxHjR3wt6Q1so P+rF0eUJxSrQAjKimlTWgbYWzOtSsnaHDpl85NFlWSTlI0GdZsiiJgcfwpYhPGTj 2gNdm9C/YqCycx5LGNE8ruWqI4XsNE3jVdXS03W4s1bYfEKcyTYC0ZRhrtlWq3Tu ZuJlDjXYPMDD6Jv7wdU6/xUYoptO7FSBcXDGbYJ+dY3bDmERLfVNvPy6YinC9L9i tRBO5AozMVfiNMkG5x6mZVP2bkjS+Q9KG2Rybbsvt44ntzt51gfUvkk0X2v+UfR5 2ZC5K98pczdOX5EXCAOlAVOzXi2WR0UACagSitgi/ZEMhB/b3x5Am7cnzMwNeOcg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrjedtgddvfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeeiuddrvdduhedrudefjedrudeivdenucfrrghrrghm pehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhush htvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id CA42C10311; Thu, 21 Mar 2019 20:36:14 -0400 (EDT) Date: Fri, 22 Mar 2019 09:36:11 +0900 From: Michael Paquier To: Tom Lane Cc: Andreas Karlsson , Chris Travers , Tatsuo Ishii , Tomas Vondra , Alvaro Herrera , euler@timbira.com.br, rjuju123@gmail.com, "Fred .Flintstone" , Postgres hackers Subject: Re: PostgreSQL pollutes the file system Message-ID: <20190322003611.GK20192@paquier.xyz> References: <20190320180832.GA11614@alvherre.pgsql> <754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com> <20190321.084132.2186284141219540889.t-ishii@sraoss.co.jp> <20190321004919.GE20192@paquier.xyz> <10036.1553176960@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="iAzLNm1y1mIRgolD" Content-Disposition: inline In-Reply-To: <10036.1553176960@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --iAzLNm1y1mIRgolD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Mar 21, 2019 at 10:02:40AM -0400, Tom Lane wrote: > So there seems like a real risk that taking away createuser would > result in security holes, not just annoying-but-trivial script update > work. That puts me more in the camp of "if we're going to do anything, > rename it with a pg_ prefix" than "if we're going to do anything, > remove it". Removing it would be a bad idea as it is very easy to mess up with things in such cases. As you mentioned, renaming the tools now would create more pain than actually solving things, so that's a bad idea anyway. I would be curious to hear the reason why such tool names have been chosen from the start. The tools have been switched to C in 9e0ab71 =66rom 2003, have been introduced by Peter Eisentraut as of 240e4c9 from 1999, and I cannot spot the thread from the time where this was discussed. -- Michael --iAzLNm1y1mIRgolD Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyULfsACgkQnvQgOdby QH3RHA//V9MZCf+F+BDnoAiqtnNfsRzQNK68CN0RkAYL6KX5MO5LOBxYTxnizBNw W22JidFh2D7+C42oxBNpj2kH906R4EYnnoOSZZ41WgJGmYAWVCqS3eleG0DDmmIX GX1vnNoKVGEfgJXeixXfrktSTpXSEMqXX3+C/FLxM5JN8w/8G1aTyk0f6SPmeXv1 3v1mB+vC4gfRqxhaeAlHZFhsK7Zhn6ezT4JqkfaYyG3lJJcSC2ZftbneFpk5VyXy vNvlsDLEortHx/Lxr8F88jHK0Jl8roFUtUsU/GoLZfdEJh5kl705HLD9COM3Ex9w /pPdD1nZg4Nlq2i8FBqbDw9Ra2GpdarlqNyWn2DjhReouGcmQ/tO/lJ2DcRsz02G 8HdPjgOHuj/mFshILcuXIdrNBrdNTr/XyTC2We03nXKgji/hwUyjhDOs3dT6Xc6s iPibwNq4SrlL8EY9VdQXZ3s7c+UNFSE6dnxMzGnmHVFzVXjf3661W0GnSVYq/wkF kFxg/btsEmtSmnY1Cj5Izk0fHjX5wiF5ZOO9Yvo79y2OpUy+BEtB+eJ6cD9zg6Kh uc09tCVwNfNSzdMq6u+Iwjsj6M14cy37skUOe3vRZlfO36jHKHC+ZLDzdmJZ5Vir Ndo3VDj+Mr9ZzKGnOUGSARaI5Wjx6LaOqjO0DAswkWm8Hp+/kUQ= =bdli -----END PGP SIGNATURE----- --iAzLNm1y1mIRgolD--