Re: Accessing pg_controldata information from SQL

Hello Bruce,

I am specifically looking for the "Datenbanksystemidentifikation" , that
would be "database system identification" - the rather unique ID of a
database installation. Third line in pg_controldata output:

pg_control-Versionsnummer: 833
Katalogversionsnummer: 200711281
----------------------------------------------------------------------------------------------
Datenbanksystemidentifikation: 5293702538224708457
----------------------------------------------------------------------------------------------
Datenbank-Cluster-Status: im Produktionsmodus
pg_control zuletzt geändert: 02.06.2009 10:54:27

Best wishes,

Harald

On Tue, Jun 2, 2009 at 4:19 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> Massa, Harald Armin wrote:
> > Hello,
> >
> > is there any way to acess the pg_controldata information via SQL?
> >
> > (running pg_controldata via shell needs file access to the postgresql
> data
> > dictionary, which is usually not given)
>
> Some of the settings have read-only variables that appear in SHOW ALL or
> the pg_settings tables, or SELECT version(). Is there something
> specific you are looking for that doesn't appear there?
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?