pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andreas Karlsson <andreas@proxel.se>
Cc: Chris Travers <chris.travers@adjust.com>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: euler@timbira.com.br, rjuju123@gmail.com, "Fred .Flintstone" <eldmannen@gmail.com>
Cc: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: PostgreSQL pollutes the file system
Date: Fri, 22 Mar 2019 09:36:11 +0900
Message-ID: <20190322003611.GK20192@paquier.xyz> (raw)
In-Reply-To: <10036.1553176960@sss.pgh.pa.us>
References: <20190320180832.GA11614@alvherre.pgsql>
	<754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com>
	<20190321.084132.2186284141219540889.t-ishii@sraoss.co.jp>
	<20190321004919.GE20192@paquier.xyz>
	<CAN-RpxBfajcAmdP_ghBjXgGYq1f+vf_Em+P6LBqfCq=av2cumg@mail.gmail.com>
	<fdbcadf7-9edd-b20d-9987-4e7d21d23b2d@proxel.se>
	<10036.1553176960@sss.pgh.pa.us>

On Thu, Mar 21, 2019 at 10:02:40AM -0400, Tom Lane wrote:
> So there seems like a real risk that taking away createuser would
> result in security holes, not just annoying-but-trivial script update
> work.  That puts me more in the camp of "if we're going to do anything,
> rename it with a pg_ prefix" than "if we're going to do anything,
> remove it".

Removing it would be a bad idea as it is very easy to mess up with
things in such cases.  As you mentioned, renaming the tools now would
create more pain than actually solving things, so that's a bad idea
anyway.

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.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (113+ messages)  latest in thread

Message-ID: <20190322003611.GK20192@paquier.xyz>
Permalink:  ../20190322003611.GK20192@paquier.xyz/
Also on:    postgresql.org/message-id/20190322003611.GK20192@paquier.xyz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-pkg-debian@postgresql.org
  Cc: michael@paquier.xyz, tgl@sss.pgh.pa.us, andreas@proxel.se, chris.travers@adjust.com, ishii@sraoss.co.jp, tomas.vondra@2ndquadrant.com, alvherre@2ndquadrant.com, eldmannen@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: PostgreSQL pollutes the file system
  In-Reply-To: <20190322003611.GK20192@paquier.xyz>
  References: <20190320180832.GA11614@alvherre.pgsql> <754d8607-682e-6f59-6870-faee5fa0820c@2ndquadrant.com> <20190321.084132.2186284141219540889.t-ishii@sraoss.co.jp> <20190321004919.GE20192@paquier.xyz> <CAN-RpxBfajcAmdP_ghBjXgGYq1f+vf_Em+P6LBqfCq=av2cumg@mail.gmail.com> <fdbcadf7-9edd-b20d-9987-4e7d21d23b2d@proxel.se> <10036.1553176960@sss.pgh.pa.us> <20190322003611.GK20192@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox