Re: PostgreSQL pollutes the file system

Many of these are gone in the modern PostgreSQL, a few remain.
https://packages.ubuntu.com/disco/amd64/postgresql-client-11/filelist

/usr/lib/postgresql/11/bin/clusterdb
/usr/lib/postgresql/11/bin/createdb
/usr/lib/postgresql/11/bin/createuser
/usr/lib/postgresql/11/bin/dropdb
/usr/lib/postgresql/11/bin/dropuser
/usr/lib/postgresql/11/bin/pg_basebackup
/usr/lib/postgresql/11/bin/pg_dump
/usr/lib/postgresql/11/bin/pg_dumpall
/usr/lib/postgresql/11/bin/pg_isready
/usr/lib/postgresql/11/bin/pg_receivewal
/usr/lib/postgresql/11/bin/pg_recvlogical
/usr/lib/postgresql/11/bin/pg_restore
/usr/lib/postgresql/11/bin/psql
/usr/lib/postgresql/11/bin/reindexdb
/usr/lib/postgresql/11/bin/vacuumdb

Can we rename clusterdb, reindexdb and vacuumdb to carry the pg_ prefix?

On Fri, Mar 22, 2019 at 3:13 AM Mark Kirkwood
<mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> wrote:
>
> On 22/03/19 3:05 PM, Tom Lane wrote:
> > Michael Paquier <michael(at)paquier(dot)xyz> writes:
> >> 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.
> > createuser, at least, dates back to Berkeley days: my copy of the
> > PG v4r2 tarball contains a "src/bin/createuser/createuser.sh" file
> > dated 1994-03-19. (The 1999 commit you mention just moved the
> > functionality around; it was there before.) So I imagine the answer
> > is that nobody at the time thought of fitting these scripts into a
> > larger ecosystem.
>
>
> FWIW the whole set is there in version 6.4.2:
>
> markir(at)vedavec:/download/postgres/src/postgresql-6.4.2/src/bin$ ls -l
> total 72
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 cleardbdir
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 createdb
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 createuser
> drwxr-sr-x 2 markir adm 4096 Dec 31 1998 CVS
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 destroydb
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 destroyuser
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 initdb
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 initlocation
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 ipcclean
> -rw-r--r-- 1 markir adm 795 Dec 19 1998 Makefile
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pgaccess
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pg_dump
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pg_encoding
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pg_id
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pg_passwd
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pgtclsh
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 pg_version
> drwxr-sr-x 3 markir adm 4096 Dec 31 1998 psql
>
> --
>
> Mark
>
>