内容

pg_stat_gssapi

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

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

pg_stat_gssapi 添加于 PostgreSQL 12。

按PostgreSQL版本定义

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

更改历史记录

示例

显示当前（未加密）连接的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"的任何评论、建议或更正 此处。