pg_controldata的使用方法

[omm@txy ~]$ pg_controldata /openGauss/data/dn
pg_control version number:            923
Catalog version number:               201611171
Database system identifier:           5932367657193972969
Database cluster state:               in production
pg_control last modified:             Wed 15 Jan 2025 05:22:26 PM CST
Latest checkpoint location:           0/4D40A1C0
Prior checkpoint location:            0/4D40A0A0
Latest checkpoint's REDO location:    0/4D40A140
Latest checkpoint's TimeLineID:       1
Latest checkpoint's full_page_writes: off
Latest checkpoint's NextXID:          51559
Latest checkpoint's NextOID:          28543
Latest checkpoint's NextMultiXactId:  2
Latest checkpoint's NextMultiOffset:  0
Latest checkpoint's oldestXID:        12666
Latest checkpoint's oldestXID's DB:   15649
Latest checkpoint's oldestActiveXID:  51559
Latest checkpoint's remove lsn:       0/3D
Time of latest checkpoint:            Wed 15 Jan 2025 05:22:26 PM CST
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:      5050
Current max_prepared_xacts setting:   800
Current max_locks_per_xact setting:   256
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
Database system TimeLine:             6
[omm@txy ~]$

posted on 2025-01-15 17:27  yq1DB  阅读(67)  评论(0)    收藏  举报

导航