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 1h6fSb-0001o0-Gy for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 17:57:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6fSa-00023F-8Q for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 17:57:04 +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 1h6fSa-000238-0l for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 17:57:04 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6fSX-0002AT-BE for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 17:57:03 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x2KHutdn013633; Wed, 20 Mar 2019 13:56:55 -0400 From: Tom Lane To: Julien Rouhaud cc: Euler Taveira , Tatsuo Ishii , chris.travers@adjust.com, Andreas Karlsson , eldmannen@gmail.com, PostgreSQL Hackers Subject: Re: PostgreSQL pollutes the file system In-reply-to: References: <7b9b6804-1575-3502-d9c9-91d324c913bd@proxel.se> <29226.1553091573@sss.pgh.pa.us> <20190320.233927.1093147102517606462.t-ishii@sraoss.co.jp> Comments: In-reply-to Julien Rouhaud message dated "Wed, 20 Mar 2019 18:36:13 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <13631.1553104615.1@sss.pgh.pa.us> Date: Wed, 20 Mar 2019 13:56:55 -0400 Message-ID: <13632.1553104615@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Julien Rouhaud writes: > On Wed, Mar 20, 2019 at 6:25 PM Euler Taveira wrote: >> createdb, dropdb, createuser, dropuser, reindexdb are binaries that >> confuse most newbies. Which tool is theses binaries from? The names >> does not give a hint. How often those confusing name tools are used? > initdb is probably an order of magnitude worse name than all of these. Meh. The ones with "db" in the name don't strike me as mortal sins; even if you don't recognize them as referring to a "database", you're not likely to guess wrongly that you know what they do. The two that seem the worst to me are createuser and dropuser, which not only have no visible connection to "postgres" or "database" but could easily be mistaken for utilities for managing operating-system accounts. We managed to get rid of createlang and droplang in v10, and there hasn't been that much push-back about it. So maybe there could be a move to remove createuser/dropuser? Or at least rename them to pg_createuser and pg_dropuser. But I think this was discussed (again) during the v10 cycle, and we couldn't agree to do more than get rid of createlang/droplang. regards, tom lane