Sorry, forgot the reply all :-)
On Tue, Mar 31, 2020 at 11:39 AM Andrus <kobruleht2@xxxxxx> wrote:
Hi,>See the section about sslcompression in https://www.postgresql.org/docs/9.2/libpq-connect.html. It should be your answer.I addedsslcompression=1to psqlodbc connection string but log file shows that connection is still uncompressed:LOG: connection authorized: user=me database=mydb SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, bits=256, compression=off)Maybe because according to TLSv1.3 standard, compression is no more allowed or psqlodbc does not pass it to pglib.How to compress ?Andrus.
Updated doc reference:
They mention that compression is insecure and disabled by default. Taking this into account, compression will require that both ODBC and PostgreSQL are set up with compression enabled. I could not figure out quickly whether this requires also recompiling the code...
--
Olivier Gautherot
Tel: +33 6 02 71 92 23