Mastering PostgreSQL 12 - Third Edition

Checking SSL connections

Many people running PostgreSQL use SSL to encrypt connections from the server to the client. More recent versions of PostgreSQL provide a view so that we can gain an overview of those encrypted connections, that is, pg_stat_ssl:

test=# \d pg_stat_ssl               View "pg_catalog.pg_stat_ssl"    Column     |  Type   | Collation | Nullable | Default ---------------+---------+-----------+----------+--------- pid           | integer |           |          |  ssl           | boolean |           |          |  version       | text    |           |          |  cipher        | text    |           |          |  bits          | integer |           |          |  compression   | boolean |           |          |  client_dn     | text    |           |          |  client_serial | numeric |           |          |  issuer_dn     | text    |           |          | 

Every process is represented by the process ID. If a connection uses SSL, the second column is set to true. The third and ...