Re: Accessing pg_controldata information from SQL
| От | Massa, Harald Armin |
|---|---|
| Тема | Re: Accessing pg_controldata information from SQL |
| Дата | |
| Msg-id | e3e180dc0906030006m5883dd98y9328b486e7cdd647@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Accessing pg_controldata information from SQL (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: Accessing pg_controldata information from SQL
|
| Список | pgsql-general |
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
--
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?
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@momjian.us> 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@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?
В списке pgsql-general по дате отправления: