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