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 1h6jbp-0005mO-99 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 22:22:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h6jbo-0001lV-39 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 22:22:52 +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 1h6jbn-0001lO-N8 for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 22:22:51 +0000 Received: from mail-wm1-x344.google.com ([2a00:1450:4864:20::344]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6jbk-0003YB-Kk for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 22:22:51 +0000 Received: by mail-wm1-x344.google.com with SMTP id q16so819122wmj.3 for ; Wed, 20 Mar 2019 15:22:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=9BtxmLhHzAXaqgYtwcr0+thSyQHGKWzGB8ruUZVdk6c=; b=fbloI6AmPWlj2VatKHYk7lH3t8wZkesGGyKEdlK9hiDnZGY7C/CtfAmbdRTEEa2W2t zswruqgpip3cYflX83VYcNQSNZ7zqsOFfLmLM97Qof9MvwDmWMwRYp9PAh6Ws5EdJYjr AMNaC0kUOzmDL+TDbK7ZcbUYHgJRg4zN9s3O9KdDXc1Ue1ygRqj0/YmzGpsUNdM+NJDV V3OCAOx36daZrqRlFMXtegWPBVK/uDdZzriMtLVr1HOXfsuKkDrX+3AFQW2L78EFC+e+ TRZEE4ZJysoGmxWqD0p6irbC8hBwDqmYSAJ5t99a9CN2odnebiFLGtAev/4el3n2hGy2 WU8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=9BtxmLhHzAXaqgYtwcr0+thSyQHGKWzGB8ruUZVdk6c=; b=j8JmiLDOhW+7+RK6BOqSaKMhYiRy8JyIdB+Se0dHjtD3MflWg+kWSJKIjcW+B6RaKt fw3YnnbrfATSXMN0vBSlxKKvryRaRxaDnODfQhsKI79Oq3IeJot5XwqdxVskgzYurgvY sKitkh1aLihyqhnvAhgE1L7fznYeXT4JwbXZ+2J8OvehB0iw2TtK/17AuU2sVN1R0aTp q5XKtmMX4kniFuXqYBiRN/kep/CNz545RNVVtrwFy51gxjz3uRHcVRwO96oRBWw4QM8b clqa/y1WjI8y6kGWANyxs6mbD2s/nmYFS7J+Erz0RR4aEsrXoBdC3HEEWbWduLwnvdGI 5pfA== X-Gm-Message-State: APjAAAWmTIAfibaUiXa4I+1esHtlO3VV74YVKgJ9y9R1B//GAqoZfeOJ bquXyqMzTpWTIdqnovo43fTg4zZlV3M3nBbNzJxIbrM/tM8Ihyp892eVybDX9CmcjmMEPet8xDc 18tHKiHV1QfkvLYmeOZe/Nn7C2YMsF7i3vHA3Bj9KiJpsQ/+5c0JHaKdSAuV47ZlBevtoWPjaJX T0re6OUaA18aW8QoqIQtJWTQ== X-Google-Smtp-Source: APXvYqyhV6lzItA6j7L5bpaFXfe4hEmUe+uoeqCuVDCa1PvtFG/PbB7Q0gMSqDSbdryH2X/7awQdSw== X-Received: by 2002:a1c:5581:: with SMTP id j123mr398413wmb.10.1553120567137; Wed, 20 Mar 2019 15:22:47 -0700 (PDT) Received: from [10.137.0.17] (ip-86-49-243-43.net.upcbroadband.cz. [86.49.243.43]) by smtp.gmail.com with ESMTPSA id h131sm13374890wmh.1.2019.03.20.15.22.45 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Wed, 20 Mar 2019 15:22:46 -0700 (PDT) Subject: Re: PostgreSQL pollutes the file system To: Alvaro Herrera , Euler Taveira Cc: Tom Lane , Julien Rouhaud , Tatsuo Ishii , Chris Travers , Andreas Karlsson , "Fred .Flintstone" , PostgreSQL Hackers References: <20190320180832.GA11614@alvherre.pgsql> From: Tomas Vondra Message-ID: <754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com> Date: Wed, 20 Mar 2019 23:22:44 +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: <20190320180832.GA11614@alvherre.pgsql> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/20/19 7:08 PM, Alvaro Herrera wrote: > On 2019-Mar-20, Euler Taveira wrote: > >> Em qua, 20 de mar de 2019 às 14:57, Tom Lane escreveu: >>> >>> 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. > > Previous discussion: > https://postgr.es/m/CABUevExPrfPH5K5qM=zsT7tvfyACe+i5qjA6bfWCKKYrh8MJLw@mail.gmail.com > >> Votes? +1 to remove createuser/dropuser (and also createdb/dropdb as I >> said in the other email). However, if we don't have sufficient votes, >> let's at least consider a 'pg_' prefix. > > I vote to keep these rename these utilities to have a pg_ prefix and to > simultaneously install symlinks for their current names, so that nothing > breaks. > I don't really understand what issue are we trying to solve here. Can someone describe a scenario where this (name of the binary not clearly indicating it's related postgres) causes issues in practice? On my system, there are ~1400 binaries in /usr/bin, and for the vast majority of them it's rather unclear where do they come from. But it's not really an issue, because we have tools to do that 1) man 2) -h/--help 3) rpm -qf $file (and similarly for other packagers) 4) set --prefix to install binaries so separate directory (which some distros already do anyway) So to me this seems like a fairly invasive change (potentially breaking quite a few scripts/tools) just to address a minor inconvenience. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services