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.
