内容

pg_stat_gssapi

一个统计视图，显示有关 GSSAPI 身份验证使用情况的信息

pg_stat_gssapi 是一个 统计视图，显示有关 GSSAPI 身份验证使用情况的信息。

pg_stat_gssapi 在 PostgreSQL 12 中添加。

按 PostgreSQL 版本定义

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

更改历史记录

示例

显示当前（未加密）连接的 GSSAPI 身份验证信息，或其不存在的情况

postgres=# SELECT * FROM pg_stat_gssapi WHERE pid = pg_backend_pid();
 pid  | gss_authenticated | principal | encrypted 
------+-------------------+-----------+-----------
 5991 | f                 |           | f
(1 row)

分类

管理/运维，安全，统计/监控视图

另请参阅

pg_stat_ssl

反馈

提交任何关于 "pg_stat_gssapi" 的评论、建议或更正 此处。