On 12/09/2018 07:51 PM, Ian Barwick wrote:
On 12/09/2018 01:25 AM, Ron wrote:
>
> In v9.2 (yes, I know it's EOL; there's nothing I can do about it), what
tables
> do I query to get these values, and can I also get them from the streamed
> replication host?
>
> - Database cluster state
> - Latest checkpoint location
> - Time of latest checkpoint
The pg_control file is written directly by PostgreSQL, it does not derive
from
any tables.
From 9.6 there are a bunch of functions which will report values contained in
pg_controldata:
https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-CONTROLDATA
but you're out of luck for 9.2. The only option to query the desired
values via
SQL would be to write an extension which reads pg_controldata
(possibly as a backport of the above-mentioned functions).
Thanks. grep(1) and cut(1) make an adequate work-around.
--
Angular momentum makes the world go 'round.
