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 <br...@momjian.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 <br...@momjian.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?
