How to check is connection encrypted

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: How to check is connection encrypted
Date: 2019-03-22 09:00:49
Message-ID: 08F9F2EFA2AC46249CEDA929B773BCB9@dell2
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Old Postgres

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"

Server has symlinks server.crt and server.key in data directory
/var/lib/postgresql/9.1./main and ssl=true in postgresql.conf file.

Server is running in old Debian squueze.

Client accesses server from Windows 10 using psqlODBC driver with
sslmode=allow in connection string.

How to verify that connection is encrypted ? Is there some command in client
or server or can some protocol analyzer used if no easier way?

Andrus.

Posted also in
https://stackoverflow.com/questions/55296044/how-to-check-is-connection-encrypted

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ali Mumcu 2019-03-22 09:07:27 PostgreSQL-11 Streaming Replication Slave Recovering
Previous Message Павлухин Иван 2019-03-22 06:13:37 Column lookup in a row performance