Re: PostgreSQL pollutes the file system

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Andreas Karlsson" <andreas(at)proxel(dot)se>
Cc: "Chris Travers" <chris(dot)travers(at)adjust(dot)com>,"Alvaro Herrera" <alvherre(at)2ndquadrant(dot)com>,"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>,"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>,"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-13 15:57:44
Message-ID: 9d0bf238-255d-4ccb-8ffb-a9fc2083cbe8@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-pkg-debian

Andreas Karlsson wrote:

> The Debian packagers already use pg_createcluster for their script which
> wraps initdb, and while pg_initdb is a bit misleading (it creates a
> cluster rather than a database) it is not that bad.

But that renaming wouldn't achieve anything in relation to the stated goal,
since initdb is not in the $PATH in Debian/Ubuntu systems.
It's part of the version-specific binaries located in
/usr/lib/postgresql/$VERSION/bin, which are not meant to be called
directly, but by the pg_*cluster* scripts that you mention, or pg_wrapper.

Moreover, aside from package-specific issues, initdb can already be
invoked through "pg_ctl initdb" since 2010 and version 9.0, as
mentioned in:
https://www.postgresql.org/docs/9.0/app-initdb.html

This evolution was the result of discussions pretty much like
the present thread.
9 years later, who bothers to use or recommend the new form?
AFAICS nobody cares.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-04-13 16:13:20 Re: hyrax vs. RelationBuildPartitionDesc
Previous Message Tom Lane 2019-04-13 15:53:39 Re: hyrax vs. RelationBuildPartitionDesc

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message apt.postgresql.org Repository Update 2019-04-14 11:08:05 pgbackrest updated to version 2.12-1.pgdg+1
Previous Message Fred .Flintstone 2019-04-13 13:43:42 Re: PostgreSQL pollutes the file system