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
[postgres@fpslbxhaprl05 ~]$ pg_controldata
pg_control version number: 922
Catalog version number: 201204301
Database system identifier: 6114483497489611387
Database cluster state: in production
pg_control last modified: Sat 08 Dec 2018 11:08:56 AM EST
Latest checkpoint location: C50/87A8F300
Prior checkpoint location: C50/85506608
Latest checkpoint's REDO location: C50/85B86620
Latest checkpoint's TimeLineID: 1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0/1965571123
Latest checkpoint's NextOID: 158912675
Latest checkpoint's NextMultiXactId: 18962475
Latest checkpoint's NextMultiOffset: 38526531
Latest checkpoint's oldestXID: 1769771528
Latest checkpoint's oldestXID's DB: 16384
Latest checkpoint's oldestActiveXID: 1965571123
Time of latest checkpoint: Sat 08 Dec 2018 10:56:56 AM EST
Minimum recovery ending location: 0/0
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
Current wal_level setting: hot_standby
Current max_connections setting: 250
Current max_prepared_xacts setting: 0
Current max_locks_per_xact setting: 320
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
--
Angular momentum makes the world go 'round.
