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 1h9CJi-00077C-C8 for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Mar 2019 17:26:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9CJg-0004x2-Sd for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Mar 2019 17:26:20 +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 1h9CJg-0004wA-CA for pgsql-hackers@lists.postgresql.org; Wed, 27 Mar 2019 17:26:20 +0000 Received: from mail-wr1-x442.google.com ([2a00:1450:4864:20::442]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9CJc-0006b8-KX for pgsql-hackers@lists.postgresql.org; Wed, 27 Mar 2019 17:26:18 +0000 Received: by mail-wr1-x442.google.com with SMTP id q1so19593811wrp.0 for ; Wed, 27 Mar 2019 10:26:16 -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:openpgp:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=3743MZyyyGaTdOONsvJgB29nkY4pSp7H2CzXJw8DWmY=; b=0WHAX4/Jd34VwKhX3Y2rFX5AwRNq4QPTKDV5GSHc0CUZEL3jnGYmNXx4jhlBlmXfaV 64q+yW762CFhbyN/tAFnpdcJmW8BFLdDggVR+fi0HP1DxAimZ8DXL5xFxc+6Gm7M5qhj OifXaAxKl2NMxtsygEYBVK7O68/QhduvucWcbQ4mAdKiEK8Jext7okf+UJM6k1Y9revF cNrk5+Q95sEHAgLpwOoruQ0ROTJ0K+w5F7DDDoEG6aF/Ac1CaBs4F+pJgm5Do0/Xn+Gx OPlXZNSkYJV9tD/dlerRK1XStFGf1vvp89RkuoONS2/b0X+iPdmDIBM8UF9MeEdwDAFX qsjg== 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:openpgp:message-id :date:user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=3743MZyyyGaTdOONsvJgB29nkY4pSp7H2CzXJw8DWmY=; b=fjoyWeGVqmGEf7HcpgEJb89XxFPe+GmIw2U1HwuUEsd4vffINRNshMVcyLJR2c3bG5 g9bM26fMJirS92jxJj+5rFIRnf2idsXYvgrwvuslk/zrzCtlg80tqezrfxHC6gsLE4I/ jeXnUrpWXx59ZVLO5zd4rotiyLMkQxz4OTKlBTYJDTSsYQjMbwBgliY9gWFySicTHnde z+5l8rfy5MiSZXuNh9Dw4VWDTQjor/2b1WQCiDtN33/eF55crpf7Emp1M4DVzecz2vuR x/WATumTJT2vVE+iqZ+wTgHCbNLg92uTCGhdRT2a7Pdo52/ZZCsPqw8V5HPyEMg0Z4oX U+ng== X-Gm-Message-State: APjAAAXG352IDguJIUh5nqlxusaoD0VA4yap0LFmVsnYy48878ptTHUk 6rTUAiBJlEN8vceMH89NjQZOuHszyXq4G5nXWfdBHV6IieLJQIDJUR8N1ngjvovwkGaYCYYpe70 B1rEONeuj5T3QVrEV5CsWnOEybDuZRBF3EkC6BfLOmOXr426DLg+ql6h+ikarMCBes7C3T6O3Il wB5RL6eD/IXBXnm5/2puw= X-Google-Smtp-Source: APXvYqxMM50BA0XkFuYK+U1j5PQ8fw1POolNcfSLwdmmVvA6GYKurgcCFFd14f8pbfGW9AUJtJ0kLw== X-Received: by 2002:a5d:670b:: with SMTP id o11mr13496173wru.125.1553707573986; Wed, 27 Mar 2019 10:26:13 -0700 (PDT) Received: from [192.168.0.237] (static-84-42-175-93.net.upcbroadband.cz. [84.42.175.93]) by smtp.gmail.com with ESMTPSA id 132sm876361wmd.30.2019.03.27.10.26.12 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 27 Mar 2019 10:26:12 -0700 (PDT) Subject: Re: PostgreSQL pollutes the file system To: Tomas Vondra , Andreas Karlsson Cc: "Fred .Flintstone" , Mark Kirkwood , Tom Lane , Michael Paquier , Chris Travers , Tatsuo Ishii , Alvaro Herrera , Euler Taveira , Julien Rouhaud , Postgres hackers References: <20190321004919.GE20192@paquier.xyz> <10036.1553176960@sss.pgh.pa.us> <20190322003611.GK20192@paquier.xyz> <31754.1553220346@sss.pgh.pa.us> <3edd2644-eaf2-41e0-aa7a-92786d25b29c@catalyst.net.nz> <20190327135116.GA17983@development> <044a865f-c0c2-70e4-f4d0-ec841d701fda@proxel.se> <20190327142657.GC17983@development> From: Petr Jelinek Openpgp: preference=signencrypt Message-ID: <2f06f405-3c07-a55a-5558-4af566867c3d@2ndquadrant.com> Date: Wed, 27 Mar 2019 18:26:11 +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: <20190327142657.GC17983@development> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 27/03/2019 15:26, Tomas Vondra wrote: > On Wed, Mar 27, 2019 at 03:07:24PM +0100, Andreas Karlsson wrote: >> On 3/27/19 2:51 PM, Tomas Vondra wrote: >>> I think the consensus in this thread (and the previous ancient ones) is >>> that it's not worth it. It's one thing to introduce new commands with >>> the >>> pg_ prefix, and it's a completely different thing to rename existing >>> ones. >>> That has inherent costs, and as Tom pointed out the burden would fall on >>> people using PostgreSQL (and that's rather undesirable). >>> >>> I personally don't see why having commands without pg_ prefix would be >>> an issue. Especially when placed in a separate directory, which >>> eliminates >>> the possibility of conflict with other commands. >> >> I buy that it may not be worth breaking tens of thousands of scripts >> to fix this, but I disagree about it not being an issue. Most Linux >> distributions add PostgreSQL's executables in to a directory which is >> in the default $PATH (/usr/bin in the case of Debian). And even if it >> would be installed into a separate directory there would still be a >> conflict as soon as that directory is added to $PATH. >> > > That is true, of course. It's only partially true, for example on my systems: Debian/Ubuntu: $ readlink -f /usr/bin/createuser /usr/share/postgresql-common/pg_wrapper Centos (PGDG package): readlink -f /usr/bin/createdb /usr/pgsql-11/bin/createdb This also means that the idea about symlinks is something packages already do. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services