From: Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Euler Taveira <euler@timbira.com.br>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: chris.travers@adjust.com, Andreas Karlsson <andreas@proxel.se>
Cc: eldmannen@gmail.com, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: PostgreSQL pollutes the file system
Date: Wed, 20 Mar 2019 19:10:25 +0100
Message-ID: <20190320191025.22e3a5c1@firost> (raw)
In-Reply-To: <13632.1553104615@sss.pgh.pa.us>
References: <7b9b6804-1575-3502-d9c9-91d324c913bd@proxel.se>
<CAN-RpxBb1LECssnFRZ4LLxWpKPg2HrfH_P2cs_i0hEj3a52fhQ@mail.gmail.com>
<29226.1553091573@sss.pgh.pa.us>
<20190320.233927.1093147102517606462.t-ishii@sraoss.co.jp>
<CAHE3wgip89NYAqQMJvi-JfpTuaoT68YUfrin0AB_cLkp8XyZ-A@mail.gmail.com>
<CAOBaU_ag1EaE7=v8tgZfTwRaqW0jHFXchQqQEcguB737NbXz6w@mail.gmail.com>
<13632.1553104615@sss.pgh.pa.us>
On Wed, 20 Mar 2019 13:56:55 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Julien Rouhaud <rjuju123@gmail.com> writes:
> > On Wed, Mar 20, 2019 at 6:25 PM Euler Taveira <euler@timbira.com.br>
> > wrote:
> >> createdb, dropdb, createuser, dropuser, reindexdb are binaries that
> >> confuse most newbies. Which tool is theses binaries from? The names
> >> does not give a hint. How often those confusing name tools are used?
>
> > initdb is probably an order of magnitude worse name than all of these.
>
> Meh. The ones with "db" in the name don't strike me as mortal sins;
> even if you don't recognize them as referring to a "database", you're
> not likely to guess wrongly that you know what they do. The two that
> seem the worst to me are createuser and dropuser, which not only have
> no visible connection to "postgres" or "database" but could easily
> be mistaken for utilities for managing operating-system accounts.
>
> 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.
If you rename them, rename as pg_createrole and pg_droprole :)
I teach people not to use "CREATE USER/GROUP", but each time I have to tell
them "Yes, we kept createuser since 8.1 where roles has been introduced for
backward compatibility. No, there's no createrole".
++
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: jgdr@dalibo.com, tgl@sss.pgh.pa.us, rjuju123@gmail.com, euler@timbira.com.br, ishii@sraoss.co.jp, andreas@proxel.se, pgsql-hackers@lists.postgresql.org
Subject: Re: PostgreSQL pollutes the file system
In-Reply-To: <20190320191025.22e3a5c1@firost>
References: <7b9b6804-1575-3502-d9c9-91d324c913bd@proxel.se> <CAN-RpxBb1LECssnFRZ4LLxWpKPg2HrfH_P2cs_i0hEj3a52fhQ@mail.gmail.com> <29226.1553091573@sss.pgh.pa.us> <20190320.233927.1093147102517606462.t-ishii@sraoss.co.jp> <CAHE3wgip89NYAqQMJvi-JfpTuaoT68YUfrin0AB_cLkp8XyZ-A@mail.gmail.com> <CAOBaU_ag1EaE7=v8tgZfTwRaqW0jHFXchQqQEcguB737NbXz6w@mail.gmail.com> <13632.1553104615@sss.pgh.pa.us> <20190320191025.22e3a5c1@firost>
* 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