Re: PostgreSQL pollutes the file system

From: Chris Travers <chris(dot)travers(at)adjust(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>, "Fred (dot)Flintstone" <eldmannen(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Joe Conway <mail(at)joeconway(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Christoph Berg <myon(at)debian(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Andreas Karlsson <andreas(at)proxel(dot)se>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Michael Paquier <michael(at)paquier(dot)xyz>, Chris Travers <chris(dot)travers(at)adjust(dot)com>, 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-04-12 15:14:51
Message-ID: CAN-RpxBT_R9sQjQgBOD3H5P22JYzE1W1x+iTVWZt=TexDtYBxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-pkg-debian

On Fri, Apr 12, 2019 at 3:20 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

> On 2019-Apr-12, Daniel Gustafsson wrote:
>
> > There are many good reasons for the changes proposed in this thread, but
> I'm
> > not sure if discoverability is one. Relying on autocompleting a
> filename to
> > figure out existing tooling for database maintenance and DBA type
> operations
> > seems like a fragile usecase.
> >
> > If commandline discoverability is of importance, providing a summary of
> the
> > tools in "man postgresql" seems like a better option.
>
> The first comment in the LWN article:
> "It's broken and obviously a bad idea but we've been doing it for so long
> we
> shouldn't attempt to fix it"
>
> IMO the future is longer than the past, and has more users, so let's do
> it right instead of perpetuating the mistakes.
>

I agree we should look at fixing these. However I have two concerns.

1. naming things is surprisingly hard. How sure are we that we can do this
right? Can we come up with a correct name for initdb? Maybe
pg_createcluster?
2. How long would our deprecation cycle be? 5 years? 10 years? Given
that people may need to support multiple versions I would propose no
warnings until both formats are supported, then warnings for 2 years, then
drop the old ones.

>
>
> ... unless you think PostgreSQL is going to become irrelevant before
> 2050.
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

--
Best Regards,
Chris Travers
Head of Database

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com
Saarbrücker Straße 37a, 10405 Berlin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2019-04-12 15:19:20 Re: PostgreSQL pollutes the file system
Previous Message Fred .Flintstone 2019-04-12 14:56:58 Re: PostgreSQL pollutes the file system

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Andreas Karlsson 2019-04-12 15:19:20 Re: PostgreSQL pollutes the file system
Previous Message Fred .Flintstone 2019-04-12 14:56:58 Re: PostgreSQL pollutes the file system