pg.ddx.io  pgsql-pkg-debian@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: 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 13:56:55 -0400
Message-ID: <13632.1553104615@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOBaU_ag1EaE7=v8tgZfTwRaqW0jHFXchQqQEcguB737NbXz6w@mail.gmail.com>
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>

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.  But I think this was discussed
(again) during the v10 cycle, and we couldn't agree to do more than
get rid of createlang/droplang.

			regards, tom lane




view thread (113+ messages)  latest in thread

Message-ID: <13632.1553104615@sss.pgh.pa.us>
Permalink:  ../13632.1553104615@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/13632.1553104615@sss.pgh.pa.us

 · 

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

* 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