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 1h79gk-0008SG-MQ for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 02:13:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h79gj-0004Hc-4m for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 02:13:41 +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 1h79gi-0004HU-TV for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 02:13:40 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h79gd-0006HT-0Z for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 02:13:39 +0000 Received: from [IPv6:2404:130:0:1000:222:4dff:fe88:a586] (unknown [IPv6:2404:130:0:1000:222:4dff:fe88:a586]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 0E99E81612; Fri, 22 Mar 2019 15:13:27 +1300 (NZDT) Subject: Re: PostgreSQL pollutes the file system To: Tom Lane , Michael Paquier Cc: Andreas Karlsson , Chris Travers , Tatsuo Ishii , Tomas Vondra , Alvaro Herrera , euler@timbira.com.br, 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> <10036.1553176960@sss.pgh.pa.us> <20190322003611.GK20192@paquier.xyz> <31754.1553220346@sss.pgh.pa.us> From: Mark Kirkwood Openpgp: preference=signencrypt Autocrypt: addr=mark.kirkwood@catalyst.net.nz; prefer-encrypt=mutual; keydata= mQGiBEifoLIRBADnzz1YAQxN+ajn3XhoyTWmp4hHTE05y1Ai0Hf4Et6HYohOw14eFzpzgEpd nbtxbs/FDprNC1d2dJ+J67qLzwKW6k95xekMWVtBQJ+tm7W9GPQ/wSSeOiya2tUO7TnjiS4H V0U0A2v6iiNDhUBpEiLQ3/09cXdJ3QuDQPP12gRFSwCgj+y/4HHUQeuQI6KYTZ6ynHYQrK8D /jYSakbQohDv/z9Z+PC4tgKugbkSumQC3q8G99z4idl1jEIAexJi89lAjrrVq1/WqdUqh0in ptsmh5Hk6eM24hqV36dYsvcYoDm3phAPIvEVYXwU9TPeqmxy46obUYpqymWl/EtZN9lIDqwU fS1SC9naB7Z1b03aAuvEXJwAdWg6BACp6SIWWvFc6ESdzkQ/5FtvHvq1grDa95y9Dzw9MBj+ YvWSxBYJo38oqidBGhUsvAAAl5Xw82bbYIQGuw0UgYjg9z8sUapZiNp+Le+gP6DDc7Jyw51b eVKTDRjc/GH6hLINlEyWlW3jwUVEKLwZNpOcGTTgfwvPITpM8+1sqQ6egLQtTWFyayBLaXJr d29vZCA8bWFyay5raXJrd29vZEBjYXRhbHlzdC5uZXQubno+iGAEExECACAFAkifoLICGwMG CwkIBwMCBBUCCAMEFgIDAQIeAQIXgAAKCRCn/vj7UjxSJvn3AKCKsXwnda7/3zTYe01FRRnk GltvIQCcD+5qpmZ4AzvfcsFqZ1rw/reu9YW5Ag0ESJ+guRAIANEGLgCM28cWn1rg28ZpY4bC xUY/DMoQMyG+3oJW5vDYOi9BYdIsH+a3mRk/ElG4r9vlWrSQQwAuDayVH30RuBJU2xHKOx2d u22W54SU7Y+fOZS8IUfffgqnKGPkPucM5eLHIiQ33kiNUl7Ho0kDli3rfe5Jyz2tZGP3FB5s 0u0v23wu7RltzgsFkxhI5kiPBBI0CVdr4w3s1gJM7id7TL8je8IOw/R+VadMn8Us9V9Hr4Yc iXhEwtkT3A9RA6ZZee3E3N09ZKjh3dxID2PMRxKPEUAuOELmVzpA77z0Sz6sZXtJgNLLvIjB iYvpZscbAGf5fjB8eBn1Kmmzow+tFy8AAwUH/ArPiMQquxtsmFUqMef5k80j66+/mDEbt9xV rz1MvXZ5NH4KVMUmgXlRN4yIOVyh/mMjiJ+DEBK/Tp4mcgQqhst2D0p/lvd3/QxtVGWts73y IAhRhWvq4jCC6Oy7IDrjRbnO0GEpumiMiT2kko1MCpXwBuJlKUxjlmlwEsKv2fbIsuGlES1u /QrLAk1ePfh5VDyKM5z+WT3GMDolrabehI8q5f0ZWPmN63Me6IM6Oqf5kYuRH0gwAauO3/bF 6NjNsQvM6lm0MbcOzSBNdH/Aru6QPbhscArMUx2opn7gkYg8wCN+Bd1Se1dQTtAcDrEBmR5i aoCbEZYkCqVAJF/C5j6ISQQYEQIACQUCSJ+guQIbDAAKCRCn/vj7UjxSJn5/AJ4hzPttJ18v gOljiFMBvwIk2HIMTQCfYMk+dS/ixjmPGZ55dk9MNuaLSYQ= Message-ID: <3edd2644-eaf2-41e0-aa7a-92786d25b29c@catalyst.net.nz> Date: Fri, 22 Mar 2019 15:13:45 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: <31754.1553220346@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-GB List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 22/03/19 3:05 PM, Tom Lane wrote: > Michael Paquier writes: >> 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 >> from 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. > createuser, at least, dates back to Berkeley days: my copy of the > PG v4r2 tarball contains a "src/bin/createuser/createuser.sh" file > dated 1994-03-19. (The 1999 commit you mention just moved the > functionality around; it was there before.) So I imagine the answer > is that nobody at the time thought of fitting these scripts into a > larger ecosystem. FWIW the whole set is there in version 6.4.2: markir@vedavec:/download/postgres/src/postgresql-6.4.2/src/bin$ ls -l total 72 drwxr-sr-x 3 markir adm 4096 Dec 31  1998 cleardbdir drwxr-sr-x 3 markir adm 4096 Dec 31  1998 createdb drwxr-sr-x 3 markir adm 4096 Dec 31  1998 createuser drwxr-sr-x 2 markir adm 4096 Dec 31  1998 CVS drwxr-sr-x 3 markir adm 4096 Dec 31  1998 destroydb drwxr-sr-x 3 markir adm 4096 Dec 31  1998 destroyuser drwxr-sr-x 3 markir adm 4096 Dec 31  1998 initdb drwxr-sr-x 3 markir adm 4096 Dec 31  1998 initlocation drwxr-sr-x 3 markir adm 4096 Dec 31  1998 ipcclean -rw-r--r-- 1 markir adm  795 Dec 19  1998 Makefile drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pgaccess drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pg_dump drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pg_encoding drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pg_id drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pg_passwd drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pgtclsh drwxr-sr-x 3 markir adm 4096 Dec 31  1998 pg_version drwxr-sr-x 3 markir adm 4096 Dec 31  1998 psql -- Mark