Tables(s) that feed pg_controldata

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Tables(s) that feed pg_controldata
Date: 2018-12-08 16:25:37
Message-ID: 62c43250-70ad-479b-d3ef-9860114eba43@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-12-08 17:30:48 pg_ctl kill INT vs. pg_cancel_backend
Previous Message Tony Shelver 2018-12-08 08:14:46 Re: Importing tab delimited text file using phpPgAdmin 5.1 GUI