Skip site navigation (1) Skip section navigation (2)

Re: Making pg_config and pg_controldata output available via SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joshua Tolley <eggyknap(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Making pg_config and pg_controldata output available via SQL
Date: 2010-02-03 19:32:47
Message-ID: 1883.1265225567@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Joshua Tolley <eggyknap(at)gmail(dot)com> writes:
> I'd really like to see the data from pg_config and pg_controldata available
> through SQL, such as by adding output to pg_show_all_settings(), or adding new
> SRFs named something like pg_config() and pg_controldata(). Does this make as
> much sense to the rest of the world as it does to me? In particular it's
> useful to be able to find $libdir without requiring pg_config, as some
> packagers tend not to include it in anything put the -dev packages, but all
> those settings seem useful to have on hand, and in at least most cases
> shouldn't be tough to expose via SQL. Comments?

I wonder whether there's a security issue there.  Telling an attacker
whether you've been built with feature X seems like possibly useful
info that he couldn't otherwise get without local machine access.
In particular, we already try to avoid exposing server filesystem
path information.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-02-03 19:33:14
Subject: Re: PG 9.0 and standard_conforming_strings
Previous:From: Mark MielkeDate: 2010-02-03 19:30:15
Subject: Re: PG 9.0 and standard_conforming_strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group