巡检人:小麦苗　QQ:646634621　微信公众号：DB宝　提供OCP、OCM、高可用（rac+dg）、PostgreSQL和MySQL培训　BLOG地址: https://www.dbaup.com 若需要脚本可私聊我
TDSQL for PostgreSQL（原 TBase）数据库巡检报告

Copyright (c) 2015-2100 (https://www.dbaup.com) dbaup. All rights reserved.

巡 检 人：小麦苗([QQ：646634621] [微信公众号：DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训])
版 本 号：v7.0.0
修改日期：2022-04-11 18:28:00

[转到页底]

目录
总体概况 实例信息数据库实例信息 数据库基本信息数据库的总体概况、版本、主机情况、数据库负载情况、数据库属性等 所有表空间所有表空间 当前客户端连接信息当前客户端连接信息 前几张大表前几张大表
当前库的所有数据库对象当前库的所有数据库对象
锁情况 所有进程
SQL部分 总执行时间最长的SQL 最耗IO的SQL 最耗共享内存
索引部分
高可用情况 主从流复制情况主从流复制情况 逻辑复制PG逻辑复制情况
数据库性能 参数配置 pg_hba参数文件 后台写进程统计信息
其它 用户和角色 所有插件 获取已安装的PostgreSQL的信息获取已安装的PostgreSQL的信息，表pg_config


数据库总体概况

● 集群节点信息
node_name node_type node_port node_host nodeis_primary nodeis_preferred node_id node_cluster_name
gtm G 50001 172.72.6.100 t f 428125959 tbase_cluster
cn001 C 30004 172.72.6.100 f f -264077367 tbase_cluster
cn002 C 30004 172.72.6.101 f f -674870440 tbase_cluster
dn001 D 40004 172.72.6.100 t t 2142761564 tbase_cluster
dn002 D 40004 172.72.6.101 f f -17499968 tbase_cluster

● 数据组信息
group_name default_group group_members
default_group 1 16385 16386

● 实例信息
pg_start_time server_ip server_port client_ip client_port server_version primary_or_standby now_date
2022-04-11 16:35:15.190857+08 172.72.6.100 30004 172.72.6.1 2735 PostgreSQL 10.0 TBase V2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit primary 2022-04-11 17:15:31.280137+08

● 数据库基本信息
Name Owner Encoding Collate Ctype Access privileges Size Tablespace Description
lhrdb tbase UTF8 en_US.UTF-8 en_US.UTF-8   19 MB pg_default  
postgres tbase UTF8 en_US.UTF-8 en_US.UTF-8   18 MB pg_default default administrative connection database
template0 tbase UTF8 en_US.UTF-8 en_US.UTF-8 =c/tbase
tbase=CTc/tbase		 18 MB pg_default unmodifiable empty database
template1 tbase UTF8 en_US.UTF-8 en_US.UTF-8 =c/tbase
tbase=CTc/tbase		 18 MB pg_default default template for new databases
● 查看各数据库数据创建时间
datname size access modification change creation isdir
postgres 3 2022-04-11 16:35:11+08 2022-04-11 16:35:08+08 2022-04-11 16:35:08+08   f
lhrdb 3 2022-04-11 16:43:43+08 2022-04-11 16:42:00+08 2022-04-11 16:42:00+08   f
template1 3 2022-04-11 16:35:06+08 2022-04-11 16:35:05+08 2022-04-11 16:35:05+08   f
template0 3 2022-04-11 16:35:09+08 2022-04-11 16:35:07+08 2022-04-11 16:35:07+08   f

● 所有表空间
oid Name Owner Location Access privileges Options Size Description
1663 pg_default tbase       72 MB  
1664 pg_global tbase       3767 kB  

● 当前客户端连接信息
current_user current_database pg_backend_pid
tbase postgres 23518

● 前几张大表
db schemaname relname rowcount table_size indexes_size total_size
postgres public test1 0 16 kB 0 bytes 16 kB

[回到目录]

锁情况

● 所有进程

● 总计
最大连接数 当前连接数 剩余连接数
500 14 486

● 详情
datid datname pid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change wait_event_type wait_event state backend_xid backend_xmin query backend_type
    19456             2022-04-11 16:35:15.354422+08       Activity AutoVacuumMain         autovacuum launcher
    19465 10 tbase         2022-04-11 16:35:15.35662+08       Activity LogicalLauncherMain         background worker
12449 postgres 6377 10 tbase psql 172.72.6.100   37046 2022-04-11 17:12:50.340719+08   2022-04-11 17:15:05.841949+08 2022-04-11 17:15:05.843768+08 Client ClientRead idle     select t1.file,
t1.file_ls,
(pg_stat_file(t1.file)).size as size,
(pg_stat_file(t1.file)).access as access,
(pg_stat_file(t1.file)).modification as last_update_time,
(pg_stat_file(t1.file)).change as change,
(pg_stat_file(t1.file)).creation as creation,
(pg_stat_file(t1.file)).isdir as isdir
from (select dir||'/'||pg_ls_dir(t0.dir) as file,
pg_ls_dir(t0.dir) as file_ls
from ( select './pg_wal'::text as dir
) t0
) t1
where 1=1
order by (pg_stat_file(file)).modification desc;		 client backend
12449 postgres 8333 10 tbase pgxc:cn002 172.72.6.101   55334 2022-04-11 17:14:38.285882+08     2022-04-11 17:14:38.292829+08 Client ClientRead idle       client backend
12449 postgres 23518 10 tbase psql.bin 172.72.6.1   2735 2022-04-11 17:15:31.26412+08 2022-04-11 17:15:31.358904+08 2022-04-11 17:15:31.358904+08 2022-04-11 17:15:31.358943+08     active   622 select a.* from pg_stat_activity a ; client backend
12449 postgres 8346 10 tbase pgxc:cn002 172.72.6.101   55336 2022-04-11 17:14:38.294285+08     2022-04-11 17:14:38.300965+08 Client ClientRead idle       client backend
12449 postgres 8359 10 tbase pgxc:cn002 172.72.6.101   55338 2022-04-11 17:14:38.302373+08     2022-04-11 17:14:38.309844+08 Client ClientRead idle       client backend
12449 postgres 8373 10 tbase pgxc:cn002 172.72.6.101   55340 2022-04-11 17:14:38.311255+08     2022-04-11 17:14:38.317896+08 Client ClientRead idle       client backend
12449 postgres 8386 10 tbase pgxc:cn002 172.72.6.101   55342 2022-04-11 17:14:38.319371+08     2022-04-11 17:14:38.326162+08 Client ClientRead idle       client backend
12449 postgres 8400 10 tbase pgxc:cn002 172.72.6.101   55344 2022-04-11 17:14:38.327779+08     2022-04-11 17:14:38.334584+08 Client ClientRead idle       client backend
    19454             2022-04-11 16:35:15.35257+08       Activity BgWriterHibernate         background writer
    19453             2022-04-11 16:35:15.352292+08       Activity CheckpointerMain         checkpointer
    19455             2022-04-11 16:35:15.353012+08       Activity WalWriterMain         walwriter
    19462             2022-04-11 16:35:15.353931+08                   pooler

● 锁
locktype database relation page tuple virtualxid transactionid classid objid objsubid virtualtransaction pid mode granted fastpath
relation 12449 11697               5/73 23518 AccessShareLock t t
virtualxid         5/73         5/73 23518 ExclusiveLock t t

● state_change字段长时间没有更新过的连接信息
datid datname pid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change wait_event_type wait_event state backend_xid backend_xmin query backend_type
12449 postgres 8333 10 tbase pgxc:cn002 172.72.6.101   55334 2022-04-11 17:14:38.285882+08     2022-04-11 17:14:38.292829+08 Client ClientRead idle       client backend
12449 postgres 8346 10 tbase pgxc:cn002 172.72.6.101   55336 2022-04-11 17:14:38.294285+08     2022-04-11 17:14:38.300965+08 Client ClientRead idle       client backend
12449 postgres 8359 10 tbase pgxc:cn002 172.72.6.101   55338 2022-04-11 17:14:38.302373+08     2022-04-11 17:14:38.309844+08 Client ClientRead idle       client backend
12449 postgres 8373 10 tbase pgxc:cn002 172.72.6.101   55340 2022-04-11 17:14:38.311255+08     2022-04-11 17:14:38.317896+08 Client ClientRead idle       client backend
12449 postgres 8386 10 tbase pgxc:cn002 172.72.6.101   55342 2022-04-11 17:14:38.319371+08     2022-04-11 17:14:38.326162+08 Client ClientRead idle       client backend
12449 postgres 8400 10 tbase pgxc:cn002 172.72.6.101   55344 2022-04-11 17:14:38.327779+08     2022-04-11 17:14:38.334584+08 Client ClientRead idle       client backend
12449 postgres 6377 10 tbase psql 172.72.6.100   37046 2022-04-11 17:12:50.340719+08   2022-04-11 17:15:05.841949+08 2022-04-11 17:15:05.843768+08 Client ClientRead idle     select t1.file,
t1.file_ls,
(pg_stat_file(t1.file)).size as size,
(pg_stat_file(t1.file)).access as access,
(pg_stat_file(t1.file)).modification as last_update_time,
(pg_stat_file(t1.file)).change as change,
(pg_stat_file(t1.file)).creation as creation,
(pg_stat_file(t1.file)).isdir as isdir
from (select dir||'/'||pg_ls_dir(t0.dir) as file,
pg_ls_dir(t0.dir) as file_ls
from ( select './pg_wal'::text as dir
) t0
) t1
where 1=1
order by (pg_stat_file(file)).modification desc;		 client backend

[回到目录]

SQL情况

[回到目录]

高可用情况

● 主从流复制情况

● 主库查看wal日志发送状态
pid usesysid usename application_name client_addr client_hostname client_port backend_start backend_xmin state sent_lsn write_lsn flush_lsn replay_lsn write_lag flush_lag replay_lag sync_priority sync_state

● 从库查看wal日志接收状态
pid status receive_start_lsn receive_start_tli received_lsn received_tli last_msg_send_time last_msg_receipt_time latest_end_lsn latest_end_time slot_name conninfo

● 主从库延迟数据（单位MB）
slave_latency_mb

● 主从流复制冲突统计
datid datname confl_tablespace confl_lock confl_snapshot confl_bufferpin confl_deadlock
12449 postgres 0 0 0 0 0
16388 lhrdb 0 0 0 0 0
1 template1 0 0 0 0 0
12448 template0 0 0 0 0 0

● 数据库统计（是否有坏块）
datid datname numbackends xact_commit xact_rollback blks_read blks_hit tup_returned tup_fetched tup_inserted tup_updated tup_deleted conflicts temp_files temp_bytes deadlocks blk_read_time blk_write_time stats_reset
12449 postgres 8 656 34 535 33441 82691 16971 54 2 0 0 0 0 0 0 0 2022-04-11 16:35:45.156161+08
16388 lhrdb 0 77 1 242 5958 42748 1499 51 2 0 0 0 0 0 0 0 2022-04-11 16:43:43.874565+08
1 template1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  
12448 template0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  

[回到目录]

● 逻辑复制

● 查看发布
pubname pubowner puballtables pubinsert pubupdate pubdelete

● 查看发布的表
pubname schemaname tablename

● 查看所有的订阅者
pid usesysid usename application_name client_addr client_hostname client_port backend_start backend_xmin state sent_lsn write_lsn flush_lsn replay_lsn write_lag flush_lag replay_lag sync_priority sync_state

● 复制进度
subid subname pid relid received_lsn last_msg_send_time last_msg_receipt_time latest_end_lsn latest_end_time

● 查看订阅
subdbid subname subowner subenabled subconninfo subslotname subsynccommit subpublications

● 查看订阅的表
srsubid srrelid srsubstate srsublsn srrelid

● 查看复制槽
slot_name plugin slot_type datoid database temporary active active_pid xmin catalog_xmin restart_lsn confirmed_flush_lsn

[回到目录]

数据库性能

● 相关参数

● 参数文件记录的参数
sourcefile sourceline seqno name setting applied error
/data/tbase/coord/postgresql.conf 64 1 max_connections 100 f  
/data/tbase/coord/postgresql.conf 113 2 shared_buffers 128MB f  
/data/tbase/coord/postgresql.conf 127 3 dynamic_shared_memory_type posix t  
/data/tbase/coord/postgresql.conf 479 4 log_timezone PRC t  
/data/tbase/coord/postgresql.conf 595 5 datestyle iso, mdy t  
/data/tbase/coord/postgresql.conf 597 6 timezone PRC t  
/data/tbase/coord/postgresql.conf 610 7 lc_messages en_US.UTF-8 t  
/data/tbase/coord/postgresql.conf 612 8 lc_monetary en_US.UTF-8 t  
/data/tbase/coord/postgresql.conf 613 9 lc_numeric en_US.UTF-8 t  
/data/tbase/coord/postgresql.conf 614 10 lc_time en_US.UTF-8 t  
/data/tbase/coord/postgresql.conf 617 11 default_text_search_config pg_catalog.english t  
/data/tbase/coord/postgresql.conf 699 12 pgxc_node_name cn001 t  
/data/tbase/coord/postgresql.conf 727 13 listen_addresses 0.0.0.0 f setting could not be applied
/data/tbase/coord/postgresql.conf 728 14 max_connections 500 t  
/data/tbase/coord/postgresql.conf 729 15 max_pool_size 65535 t  
/data/tbase/coord/postgresql.conf 730 16 shared_buffers 1GB t  
/data/tbase/coord/postgresql.conf 731 17 max_prepared_transactions 2000 t  
/data/tbase/coord/postgresql.conf 732 18 maintenance_work_mem 256MB t  
/data/tbase/coord/postgresql.conf 733 19 wal_level logical t  
/data/tbase/coord/postgresql.conf 734 20 max_wal_senders 64 t  
/data/tbase/coord/postgresql.conf 735 21 max_wal_size 1GB t  
/data/tbase/coord/postgresql.conf 736 22 min_wal_size 256MB t  
/data/tbase/coord/postgresql.conf 737 23 log_destination csvlog t  
/data/tbase/coord/postgresql.conf 738 24 logging_collector on t  
/data/tbase/coord/postgresql.conf 739 25 log_directory log t  
/data/tbase/coord/postgresql.conf 740 26 log_filename postgresql-%A-%H.log t  
/data/tbase/coord/postgresql.conf 741 27 synchronous_commit local t  
/data/tbase/coord/postgresql.conf 742 28 synchronous_standby_names   t  
/data/tbase/coord/postgresql.conf 746 29 port 30004 t  
/data/tbase/coord/postgresql.conf 747 30 pooler_port 31110 t  
● 重要参数
name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
archive_mode off   Write-Ahead Log / Archiving Allows archiving of WAL files using archive_command.   postmaster enum default     {always,on,off} off off     f
client_encoding UTF8   Client Connection Defaults / Locale and Formatting Sets the client's character set encoding.   user string default       SQL_ASCII UTF8     f
config_file /data/tbase/coord/postgresql.conf   File Locations Sets the server's main configuration file.   postmaster string override         /data/tbase/coord/postgresql.conf     f
data_directory /data/tbase/coord   File Locations Sets the server's data directory.   postmaster string override         /data/tbase/coord     f
hba_file /data/tbase/coord/pg_hba.conf   File Locations Sets the server's "hba" configuration file.   postmaster string override         /data/tbase/coord/pg_hba.conf     f
ident_file /data/tbase/coord/pg_ident.conf   File Locations Sets the server's "ident" configuration file.   postmaster string override         /data/tbase/coord/pg_ident.conf     f
listen_addresses *   Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to.   postmaster string command line       localhost *     t
log_directory log   Reporting and Logging / Where to Log Sets the destination directory for log files. Can be specified as relative to the data directory or as absolute path. sighup string configuration file       log log /data/tbase/coord/postgresql.conf 739 f
log_filename postgresql-%A-%H.log   Reporting and Logging / Where to Log Sets the file name pattern for log files.   sighup string configuration file       postgresql-%Y-%m-%d_%H%M%S.log postgresql-%A-%H.log /data/tbase/coord/postgresql.conf 740 f
logging_collector on   Reporting and Logging / Where to Log Start a subprocess to capture stderr output and/or csvlogs into log files.   postmaster bool configuration file       off on /data/tbase/coord/postgresql.conf 738 f
log_min_duration_statement -1 ms Reporting and Logging / When to Log Sets the minimum execution time above which statements will be logged. Zero prints all queries. -1 turns this feature off. superuser integer default -1 2147483647   -1 -1     f
log_statement none   Reporting and Logging / What to Log Sets the type of statements logged.   superuser enum default     {none,ddl,mod,all} none none     f
log_truncate_on_rotation off   Reporting and Logging / Where to Log Truncate existing log files of same name during log rotation.   sighup bool default       off off     f
max_connections 500   Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections.   postmaster integer configuration file 1 262143   100 500 /data/tbase/coord/postgresql.conf 728 f
port 30004   Connections and Authentication / Connection Settings Sets the TCP port the server listens on.   postmaster integer configuration file 1 65535   5432 30004 /data/tbase/coord/postgresql.conf 746 f

● pg_hba.conf配置文件信息（PG10新增）
line_number type database user_name address netmask auth_method options error
1 local {all} {mls_admin,audit_admin}     md5    
2 host {all} {mls_admin,audit_admin} 0.0.0.0 0.0.0.0 md5    
3 host {all} {mls_admin,audit_admin} :: :: md5    
84 local {all} {all}     trust    
86 host {all} {all} 127.0.0.1 255.255.255.255 trust    
88 host {all} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
91 local {replication} {all}     trust    
92 host {replication} {all} 127.0.0.1 255.255.255.255 trust    
93 host {replication} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
96 local {all} {all}     trust    
97 host {all} {all} 0.0.0.0 0.0.0.0 trust    
98 host {replication} {all} 0.0.0.0 0.0.0.0 trust    
99 host {all} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
100 host {replication} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
101 host {replication} {all} 172.72.6.100 255.255.255.255 trust    
102 host {all} {all} 172.72.6.100 255.255.255.255 trust    
103 host {replication} {all} 172.72.6.101 255.255.255.255 trust    
104 host {all} {all} 172.72.6.101 255.255.255.255 trust    
105 host {all} {all} 0.0.0.0 0.0.0.0 md5    
107 host {all} {tbase} 0.0.0.0 0.0.0.0 trust    

● 后台写进程统计信息
checkpoints_timed checkpoints_req checkpoint_write_time checkpoint_sync_time buffers_checkpoint buffers_clean maxwritten_clean buffers_backend buffers_backend_fsync buffers_alloc stats_reset
7 2 27572 325 290 0 0 193 0 966 2022-04-11 16:35:15.353458+08

● WAL日志切换频率（需要手动修改路径）
day_id wal_num_all wal_num_00_01 wal_num_01_02 wal_num_02_03 wal_num_03_04 wal_num_04_05 wal_num_05_06 wal_num_06_07 wal_num_07_08 wal_num_08_09 wal_num_09_10 wal_num_10_11 wal_num_11_12 wal_num_12_13 wal_num_13_14 wal_num_14_15 wal_num_15_16 wal_num_16_17 wal_num_17_18 wal_num_18_19 wal_num_19_20 wal_num_20_21 wal_num_21_22 wal_num_22_23 wal_num_23_24
20220411 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0

● 查看表膨胀信息
table_name table_size n_dead_tup n_live_tup dead_tup_ratio

[回到目录]

其它

● 当前库的所有schema
catalog_name schema_name schema_owner default_character_set_catalog default_character_set_schema default_character_set_name sql_path
postgres information_schema tbase        
postgres public tbase        
postgres pg_catalog tbase        
postgres pg_toast_temp_1 tbase        
postgres pg_temp_1 tbase        
postgres pg_oracle tbase        
postgres pg_toast tbase        

● 当前库的所有角色(用户)
rolname rolsuper rolinherit rolcreaterole rolcreatedb rolcanlogin rolreplication rolconnlimit rolpassword rolvaliduntil rolbypassrls rolconfig oid
pg_signal_backend f t f f f f -1 ********   f   4200
tbase t t t t t t -1 ********   t   10
pg_read_all_stats f t f f f f -1 ********   f   3375
pg_monitor f t f f f f -1 ********   f   3373
mls_admin f f t f t f -1 ********   f   4565
pg_read_all_settings f t f f f f -1 ********   f   3374
pg_stat_scan_tables f t f f f f -1 ********   f   3377
audit_admin f f f f t f -1 ********   f   6116

usename usesysid usecreatedb usesuper userepl usebypassrls passwd valuntil useconfig
tbase 10 t t t t ********    
mls_admin 4565 f f f f ********    
audit_admin 6116 f f f f ********    

● 所有语言
lanname lanowner lanispl lanpltrusted lanplcallfoid laninline lanvalidator lanacl
internal 10 f f 0 0 2246  
c 10 f f 0 0 2247  
sql 10 f t 0 0 2248  
plpgsql 10 t t 12431 12432 12433  

● 所有可用插件

● 所有插件（已编译）
name default_version installed_version comment
refint 1.0   functions for implementing referential integrity (obsolete)
tbase_pooler_stat 1.0   pooler statistics
tbase_memory_tools 1.0   memory wrapper for TBase
plpgsql 1.0 1.0 PL/pgSQL procedural language
cube 1.2   data type for multidimensional cubes
intarray 1.2   functions, operators, and index support for 1-D arrays of integers
stormstats 1.0   collect deeper database stats for StormDB
hstore 1.4   data type for storing sets of (key, value) pairs
uuid-ossp 1.1   generate universally unique identifiers (UUIDs)
chkpass 1.0   data type for auto-encrypted passwords
sslinfo 1.2   information about SSL certificates
pgrowlocks 1.2   show row-level locking information
dict_int 1.0   text search dictionary template for integers
btree_gist 1.5   support for indexing common datatypes in GiST
pg_trgm 1.3   text similarity measurement and index searching based on trigrams
dict_xsyn 1.0   text search dictionary template for extended synonym processing
lo 1.1   Large Object maintenance
btree_gin 1.2   support for indexing common datatypes in GIN
moddatetime 1.0   functions for tracking last modification time
pg_buffercache 1.3   examine the shared buffer cache
unaccent 1.1   text search dictionary that removes accents
pg_freespacemap 1.2   examine the free space map (FSM)
pgstattuple 1.5   show tuple-level statistics
citext 1.4   data type for case-insensitive character strings
pgcrypto 1.3   cryptographic functions
tcn 1.0   Triggered change notifications
pg_visibility 1.2   examine the visibility map (VM) and page-level visibility info
adminpack 1.0   administrative functions for PostgreSQL
pg_prewarm 1.1   prewarm relation data
tablefunc 1.0   functions that manipulate whole tables, including crosstab
amcheck 1.0   functions for verifying relation integrity
ltree 1.1   data type for hierarchical tree-like structures
tsm_system_rows 1.0   TABLESAMPLE method which accepts number of rows as a limit
tbase_subscription 1.0   support for hot and cold subscriptions and two-way subscriptions
isn 1.1   data types for international product numbering standards
pg_stat_cluster_activity 1.0   track execution statistics in whole cluster scope
pg_unlock 1.0   tools for detect and unlock all the deadlocks
autoinc 1.0   functions for autoincrementing fields
dblink 1.2   connect to other PostgreSQL databases from within a database
fuzzystrmatch 1.1   determine similarities and distance between strings
tsm_system_time 1.0   TABLESAMPLE method which accepts time in milliseconds as a limit
file_fdw 1.0   foreign-data wrapper for flat file access
pg_clean 1.0   tools for clean all the remaining 2PC transactions
timetravel 1.0   functions for implementing time travel
earthdistance 1.1   calculate great-circle distances on the surface of the Earth
intagg 1.1   integer aggregator and enumerator (obsolete)
pageinspect 1.6   inspect the contents of database pages at a low level
postgres_fdw 1.0   foreign-data wrapper for remote PostgreSQL servers
tbase_gts_tools 1.0   GTS wrapper for Tbase
seg 1.1   data type for representing line segments or floating-point intervals
insert_username 1.0   functions for tracking who changed a table

● 已安装的插件
Name Version Schema Description
plpgsql 1.0 pg_catalog PL/pgSQL procedural language

● 获取已安装的PostgreSQL的信息
name setting
BINDIR /opt/tbase/bin
DOCDIR /opt/tbase/share/doc/postgresql
HTMLDIR /opt/tbase/share/doc/postgresql
INCLUDEDIR /opt/tbase/include
PKGINCLUDEDIR /opt/tbase/include/postgresql
INCLUDEDIR-SERVER /opt/tbase/include/postgresql/server
LIBDIR /opt/tbase/lib
PKGLIBDIR /opt/tbase/lib/postgresql
LOCALEDIR /opt/tbase/share/locale
MANDIR /opt/tbase/share/man
SHAREDIR /opt/tbase/share/postgresql
SYSCONFDIR /opt/tbase/etc/postgresql
PGXS /opt/tbase/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE '--prefix=/opt/tbase' '--enable-user-switch' '--with-openssl' '--with-ossp-uuid' 'CFLAGS=-g'
CC gcc
CPPFLAGS -D_GNU_SOURCE
CFLAGS -D_PG_ORCL_ -DPGXC -DXCP -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -D_USER_SWITCH_ -g
CFLAGS_SL -fPIC
LDFLAGS -L../../src/common -Wl,--as-needed -Wl,-rpath,'/opt/tbase/lib',--enable-new-dtags
LDFLAGS_EX  
LDFLAGS_SL  
LIBS -lpgcommon -lpgport -lpthread -lssl -lcrypto -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION PostgreSQL 10.0 TBase V2

[回到目录]