Re: PostgreSQL pollutes the file system

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: euler(at)timbira(dot)com(dot)br
Cc: ishii(at)sraoss(dot)co(dot)jp, tgl(at)sss(dot)pgh(dot)pa(dot)us, chris(dot)travers(at)adjust(dot)com, andreas(at)proxel(dot)se, eldmannen(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL pollutes the file system
Date: 2019-03-20 22:56:59
Message-ID: 20190321.075659.2087873072738671224.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-pkg-debian

>> +1. As one of third party PostgreSQL tool developers, I am afraid
>> changing names of PostgreSQL commands would give us lots of pain: for
>> example checking PostgreSQL version to decide to use command "foo" not
>> "pg_foo".
>>
> 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?
> AFAICS a graphical tool or psql is used to create roles and databases.
> psql -c "stmt" can replace createdb, dropdb, createuser and dropuser.
> What about deprecate them (and remove after a support cycle)?

At least psql, initdb, pg_config, pgbench and pg_ctl for now. But I
don't want to say that renaming other commands would be fine for me
because I would like to take a liberty to extend my tool for my users.

BTW, a strange thing in the whole discussion is, installing those
PostgreSQL commands in /usr/bin is done by packagers, not PostgreSQL
core project itself. The default installation directory has been
/usr/local/pgsql/bin in the source code of PostgreSQL since it was
born, and I love the place. Forcing to install everything into
/usr/bin is distributions' policy, not PostgreSQL core project's as
far as I know. So I wonder why people don't ask the renaming request
to packagers, rather than PostgreSQL core project itself.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-03-20 22:59:24 Re: Offline enabling/disabling of data checksums
Previous Message Julien Rouhaud 2019-03-20 22:56:07 Re: [survey] New "Stable" QueryId based on normalized query text

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Tatsuo Ishii 2019-03-20 23:41:32 Re: PostgreSQL pollutes the file system
Previous Message Tomas Vondra 2019-03-20 22:22:44 Re: PostgreSQL pollutes the file system