Re: PostgreSQL pollutes the file system

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "Fred (dot)Flintstone" <eldmannen(at)gmail(dot)com>, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Michael Paquier <michael(at)paquier(dot)xyz>, Andreas Karlsson <andreas(at)proxel(dot)se>, Chris Travers <chris(dot)travers(at)adjust(dot)com>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Euler Taveira <euler(at)timbira(dot)com(dot)br>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL pollutes the file system
Date: 2019-03-27 18:03:47
Message-ID: 20190327180347.GA31173@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-pkg-debian

On 2019-Mar-27, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> > I suppose that if you're a Postgres developer, you naturally expect that
> > "createdb" creates a Postgres DB. What if you use multiple database
> > systems, and then only occasionally have to do DBA tasks? I find this
> > POV that createdb doesn't need renaming a bit self-centered.
>
> Nobody is defending the existing names as being something we'd pick
> if we were picking them today. The question is whether changing them
> is worth the pain. (And, one more time, may I point out that most
> of the pain will be borne by people not on this mailing list, hence
> unable to vote here.) I don't think there is any reasonable argument
> that said pain will be justified for any of them except maybe createuser
> and dropuser.

The implicit argument here is that existing users are a larger
population than future users. I, for one, don't believe that. I think
taking no action is a disservice to future users. Also, that modifying
the code will be utterly painful and that less administrative code will be
written in the future than has already been written.

We *could* run a poll on twitter/slack/website to get a feeling on a
wider population. That would still reach mostly existing Postgres
users, but at least it would be much more diverse than this group.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Raymond Martin 2019-03-27 18:24:41 RE: minimizing pg_stat_statements performance overhead
Previous Message Alexey Kondratov 2019-03-27 17:48:56 Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Gavin Flower 2019-03-27 20:57:41 Re: PostgreSQL pollutes the file system
Previous Message Fred .Flintstone 2019-03-27 17:40:05 Re: PostgreSQL pollutes the file system