Mastering PostgreSQL 9.6

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 to gain an overview of those encrypted connections, which is pg_stat_ssl:

test=# \d pg_stat_ssl     View "pg_catalog.pg_stat_ssl"    Column    |  Type   | Modifiers  -------------+---------+-----------  pid         | integer |   ssl         | boolean |   version     | text    |   cipher      | text    |   bits        | integer |   compression | boolean |   clientdn    | text    |  

Every process is represented by the process ID. If a connection uses SSL, the second column is set to true. The third and fourth column will define the version as well as the cipher. Finally, there are the number of bits used by the encryption algorithm, an ...