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 1h6wYe-0005Me-OE for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2019 12:12:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6wYc-0005hq-Ei for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Mar 2019 12:12:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6wYc-0005hj-6N for pgsql-hackers@lists.postgresql.org; Thu, 21 Mar 2019 12:12:26 +0000 Received: from kilimanjaro.scorpionshops.com ([82.118.24.85]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6wYa-0005jH-38 for pgsql-hackers@lists.postgresql.org; Thu, 21 Mar 2019 12:12:25 +0000 Received: from [172.17.245.123] (guest-se.mytaste.name [46.246.120.52]) by kilimanjaro.scorpionshops.com (Postfix) with ESMTPSA id 782467BC11A; Thu, 21 Mar 2019 13:12:23 +0100 (CET) Subject: Re: PostgreSQL pollutes the file system To: Chris Travers , Michael Paquier Cc: Tatsuo Ishii , Tomas Vondra , Alvaro Herrera , euler@timbira.com.br, Tom Lane , rjuju123@gmail.com, "Fred .Flintstone" , Postgres hackers References: <20190320180832.GA11614@alvherre.pgsql> <754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com> <20190321.084132.2186284141219540889.t-ishii@sraoss.co.jp> <20190321004919.GE20192@paquier.xyz> From: Andreas Karlsson Message-ID: Date: Thu, 21 Mar 2019 13:12:23 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/21/19 7:07 AM, Chris Travers wrote: > 1.  createuser/dropuser are things that I don't consider good ways of > creating users anyway.  I think we should just consider removing these > binaries.  The SQL queries are better, more functional, and can be > rolled back as a part of a larger transaction. Those binaries are pretty convenient to use in scripts since they handle SQL escaping for you, but probably not convenient enough that we would have added createuser today. Compare createuser "$USER" vs echo 'CREATE ROLE :"user" LOGIN' | psql postgres -v "user=$USER" Andreas