Search Postgresql Archives

Re: Using compression on TCP transfer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 added
 
sslcompression=1
 
to 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:
https://www.postgresql.org/docs/12/libpq-connect.html 

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 
https://www.linkedin.com/in/ogautherot/ 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux