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 16)
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 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
- PostgreSQL 13
- only shows processes with a connection, i.e. excluding various auxiliary processes which do not receive network connections (commit 5c46e7d8)
- PostgreSQL 12
- added (commit b0b39f72)
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)
References
- PostgreSQL documentation: pg_stat_gssapi