pg_stat_gssapi

A statistics view showing information about GSSAPI authentication usage

pg_stat_gssapi is a statistics view showing information about GSSAPI authentication usage.

pg_stat_gssapi was added in PostgreSQL 12.

Definition by PostgreSQL version

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 |           |          |
    

Documentation: 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 |           |          |
    

Documentation: 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 |           |          |
    

Documentation: 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 |           |          |
    

Documentation: pg_stat_gssapi

Change history

Examples

Showing GSSAPI authentication information, of absence thereof, for the current (unencrypted) connection:

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

Categories

Management / adminstration, Security, Statistics / monitoring view

See also

pg_stat_ssl