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 1h6c4D-0006aQ-VG for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 14:19: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 1h6c4C-0006ie-Gr for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Mar 2019 14:19:40 +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 1h6c4C-0006iS-5k for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 14:19:40 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h6c49-0006r2-6b for pgsql-hackers@lists.postgresql.org; Wed, 20 Mar 2019 14:19:38 +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 x2KEJXw0029227; Wed, 20 Mar 2019 10:19:33 -0400 From: Tom Lane To: Chris Travers cc: Andreas Karlsson , "Fred .Flintstone" , Postgres hackers Subject: Re: PostgreSQL pollutes the file system In-reply-to: References: <7b9b6804-1575-3502-d9c9-91d324c913bd@proxel.se> Comments: In-reply-to Chris Travers message dated "Wed, 20 Mar 2019 11:55:38 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <29225.1553091573.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Wed, 20 Mar 2019 10:19:33 -0400 Message-ID: <29226.1553091573@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Chris Travers writes: > On Wed, Mar 20, 2019 at 11:06 AM Andreas Karlsson wr= ote: >> On 3/19/19 11:19 AM, Fred .Flintstone wrote: >>> It would be better if these files were renamed to be prefixed with >>> pg_, such as pg_createdb. >>> Or even better postgresql-createdb then be reachable by through a >>> "postgresql" wrapper script. >> This topic has been discussed before e.g. in 2008 in >> https://www.postgresql.org/message-id/47EA5CC0.8040102%40sun.com and >> also more recently but I cannot find it in the archives right now. And also before that, eg https://www.postgresql.org/message-id/flat/199910091253.IAA10670%40candle.= pha.pa.us > I wouldn't be opposed to this, but I would note two points on a deprecat= ion > cycle: > 1 Given that people may have tools that work with all supported version= s > of PostgreSQL, this needs to be a long cycle, and > 2. Managing that cycle makes it a little bit of a tough sell. If we didn't pull the trigger twenty years ago, nor ten years ago, we're not likely to do so now. Yeah, it's a mess and we'd certainly do it differently if we were starting from scratch, but we're not starting from scratch. There are decades worth of scripts out there that know these program names, most of them not under our control. Every time this has been looked at, we've concluded that the distributed costs of getting rid of these program names would exceed the value; and that tradeoff gets worse, not better, as more years go by. I don't foresee it happening. regards, tom lane