On Sun, Dec 09, 2018 at 08:10:57PM -0600, Ron wrote:
> On 12/09/2018 07:51 PM, Ian Barwick wrote:
>> but you're out of luck for 9.2. The only option to query the desired
>> values via
>> SQL would be to write an extension which reads pg_controldata
>> (possibly as a backport of the above-mentioned functions).
>
> Thanks. grep(1) and cut(1) make an adequate work-around.
Perhaps. Even with that, writing an extension for 9.2 would require
copy-pasting a lot of code from pg_controldata.c and taking as well the
code which has been introduced for the various control functions.
Dirty, still doable. Adding the control functions has also refactored
the code so as getting control file data is easy for backend code (see
get_controlfile in controldata_utils.c).
(9.2 is EOL'd for one year now, you may want to upgrade.)
--
Michael