Re: Accessing pg_controldata information from SQL

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Massa, Harald Armin" <chef(at)ghum(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Accessing pg_controldata information from SQL
Date: 2009-06-02 14:19:12
Message-ID: 200906021419.n52EJCC12205@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-06-02 14:21:40 Re: Schema, databse, or tables in different system folder
Previous Message Tom Lane 2009-06-02 13:52:42 Re: How can I manually alter the statistics for a column?