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@xxxxxxxxxx> wrote:
Massa, Harald Armin wrote:Some of the settings have read-only variables that appear in SHOW ALL or
> 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)
the pg_settings tables, or SELECT version(). Is there something
specific you are looking for that doesn't appear there?
--
Bruce Momjian <bruce@xxxxxxxxxx> 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?
