Re: exposing pg_controldata and pg_config as functions

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>, Joe Conway <mail(at)joeconway(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: exposing pg_controldata and pg_config as functions
Date: 2015-09-07 23:21:07
Message-ID: 55EE1BE3.70708@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/06/2015 11:17 PM, Peter Eisentraut wrote:
> On 9/6/15 3:34 PM, Joe Conway wrote:
>> On 09/02/2015 02:54 PM, Alvaro Herrera wrote:
>>> Josh Berkus wrote:
>>>> On 09/02/2015 02:34 PM, Alvaro Herrera wrote:
>>>>> I think trying to duplicate the exact strings isn't too nice an
>>>>> interface.
>>>> Well, for pg_controldata, no, but what else would you do for pg_config?
>>> I was primarily looking at pg_controldata, so we agree there.
>>>
>>> As for pg_config, I'm confused about its usefulness -- which of these
>>> lines are useful in the SQL interface? Anyway, I don't see anything
>>> better than a couple of text columns for this case.
>> There are production environments where even the superuser has no
>> direct, local, command line access on production database servers
> But then they also have no use for the information that pg_config prints
> out.
>
>> and the
>> only interface for getting information from postgres is via a database
>> connection. So to the extent pg_config and pg_controldata command line
>> binaries are useful, so is the ability to get the same output via SQL.
>>
>> Given that, my own feeling is that if we provide a SQL interface at all,
>> it ought to be pretty much the exact same output as the command line
>> programs produce.
> That argument makes no sense to me.
>
> Again, we need to think about what actual use there is for this
> information. Just because the information exists somewhere, but you
> can't access it, doesn't mean we just need to copy it around.

I already gave a use case that you dismissed in favour of a vague
solution that we don't actually have. You seem to be the only person
objecting to this proposal.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-09-07 23:32:41 Re: exposing pg_controldata and pg_config as functions
Previous Message Alvaro Herrera 2015-09-07 22:31:48 Re: New functions