pg_controldata用法
pg_controldata是什么
官方说明:
显示一个PostgreSQL数据库集簇的控制信息
display control information of a PostgreSQL database cluster
怎么使用
[gpadmin-master@yz219 demoDataDir0]$ pwd /opt/software/gpdb-master/gpAux/gpdemo/datadirs/dbfast1/demoDataDir0 [gpadmin-master@yz219 demoDataDir0]$ pg_controldata . pg_control version number: 9600700 Catalog version number: 302006131 Database system identifier: 6865960197649762497 Database cluster state: in production pg_control last modified: 2021年06月30日 星期三 18时45分03秒 Latest checkpoint location: 0/125643B0 Prior checkpoint location: 0/125642C8 Latest checkpoint's REDO location: 0/12564378 Latest checkpoint's REDO WAL file: 000000010000000000000004 Latest checkpoint's TimeLineID: 1 Latest checkpoint's PrevTimeLineID: 1 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0:835 Latest checkpoint's NextOID: 33108 Latest checkpoint's NextRelfilenode: 24878 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Latest checkpoint's oldestXID: 529 Latest checkpoint's oldestXID's DB: 1 Latest checkpoint's oldestActiveXID: 835 Latest checkpoint's oldestMultiXid: 1 Latest checkpoint's oldestMulti's DB: 1 Latest checkpoint's oldestCommitTsXid:0 Latest checkpoint's newestCommitTsXid:0 Time of latest checkpoint: 2021年06月30日 星期三 18时45分03秒 Fake LSN counter for unlogged rels: 0/1 Minimum recovery ending location: 0/0 Min recovery ending loc's timeline: 0 Backup start location: 0/0 Backup end location: 0/0 End-of-backup record required: no wal_level setting: replica wal_log_hints setting: off max_connections setting: 250 max_worker_processes setting: 12 max_prepared_xacts setting: 250 max_locks_per_xact setting: 128 track_commit_timestamp setting: off Maximum data alignment: 8 Database block size: 32768 Blocks per segment of large relation: 32768 WAL block size: 32768 Bytes per WAL segment: 67108864 Maximum length of identifiers: 64 Maximum columns in an index: 32 Maximum size of a TOAST chunk: 8140 Size of a large-object chunk: 8192 Date/time type storage: 64-bit integers Float4 argument passing: by value Float8 argument passing: by value Data page checksum version: 1
打赏作者以资鼓励: