pg_stat_gssapi 是一个统计视图，显示GSSAPI认证使用情况的信息。
pg_stat_gssapi 在PostgreSQL 12中添加。
按 PostgreSQL 版本定义
pg_stat_gssapi (PostgreSQL 19)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-----------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
credentials_delegated | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 18)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-----------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
credentials_delegated | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 17)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-----------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
credentials_delegated | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 16)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-----------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
credentials_delegated | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 15)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 14)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 13)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
文档: pg_stat_gssapi
pg_stat_gssapi (PostgreSQL 12)
View "pg_catalog.pg_stat_gssapi"
Column | Type | Collation | Nullable | Default
-------------------+---------+-----------+----------+---------
pid | integer | | |
gss_authenticated | boolean | | |
principal | text | | |
encrypted | boolean | | |
文档: pg_stat_gssapi
变更历史
- PostgreSQL 16
- 添加了列
credentials_delegated(提交 6633cfb2)
- 添加了列
- PostgreSQL 13
- only shows processes with a connection, i.e. excluding various auxiliary processes which do not receive network connections (commit 5c46e7d8)
- PostgreSQL 12
- 添加 (提交 b0b39f72)
示例
显示当前（未加密）连接的GSSAPI认证信息，或其缺失情况
postgres=# SELECT * FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); pid | gss_authenticated | principal | encrypted ------+-------------------+-----------+----------- 5991 | f | | f (1 row)
参考资料
- PostgreSQL 文档: pg_stat_gssapi