pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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".

++




view thread (113+ messages)  latest in thread

Message-ID: <20190320191025.22e3a5c1@firost>
Permalink:  ../20190320191025.22e3a5c1@firost/
Also on:    postgresql.org/message-id/20190320191025.22e3a5c1@firost

 · 

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: 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