| From: | Krystian Bigaj <krystian(dot)bigaj(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SSL Compression - doesn't work? |
| Date: | 2014-05-08 08:22:15 |
| Message-ID: | CAN=kAeHJsJ_iNDkit1UP3zHq4E=0Mf9OUjtXbxSdzbBbJ277pA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I'm wondering how, and if SSL compression works correctly.
Here is how I tested it:
- PostgreSQL 9.3.4 x86 on Windows 7 x64
- .crt/.key files by openssl, and placed in database cluster folder
- postgres.exe ran with: --ssl="on" --ssl_cert_file="test.crt"
--ssl_key_file="test.key"
- connection made by pgadmin with SSL=prefer, SSL Compression=True
- when connected I see in properties: Encryptions=SSL encrypted, SSL
Compression=yes
- I've dumped TCP transfer and I can tell that data is encrypted
Now when I run query like:
SELECT lpad('', 1024*1024, 'A')
then I see that there is a TCP transfer of 1,01MB (so 1MB of string data,
and some pg header/data).
If I turn off SSL Compression data transfer between postgres and pgadmin is
still 1,01MB (but in properties I see SSL Compression=no)
It looks like SSL compression doesn't work, or am I missing something?
Best regards,
Krystian Bigaj
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart Bishop | 2014-05-08 10:47:18 | Re: Ubuntu Packages / Config Files |
| Previous Message | Alberto Cabello Sánchez | 2014-05-08 08:06:16 | Re: Trouble finding libpq on Centos 6.5 |