| 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: | Whole Thread | Raw Message | 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 |