On 01/15/2015 01:02 PM, Maciek Sakrejda wrote:
I'm having a hard time getting SSL compression working (or even figuring
out why it's not working) with my local Postgres server. The setting [1]
is documented to default to on, but according to the banner when I
connect with psql, it's off. It's still off even if I explicitly set
PGSSLCOMPRESSION=1:
maciek@gamera:~$ PGSSLCOMPRESSION=1 psql -h localhost
psql (9.4.0, server 9.2.9)
SSL connection (protocol: TLSv1.2, cipher: DHE-RSA-AES256-GCM-SHA384,
bits: 256, compression: off)
Type "help" for help.
Nothing interesting in the logs. As far as I can tell, my OpenSSL
version is recent enough to support this:
Noticed you are using psql from 9.4 to connect to a 9.2 server.
You might want to try the 9.2 version of psql to see if that works?
maciek@gamera:~$ ldd /usr/lib/postgresql/9.2/bin/postgres | grep ssl
libssl.so.1.0.0 => /lib/x86_64-linux-gnu/libssl.so.1.0.0
(0x00007f144a25d000)
(is that the right way to check?)
I would use :
dpkg -l | grep openssl
Which on one of my 14.04 instances gives:
ii openssl 1.0.1f-1ubuntu2.8
I'm running this on Ubuntu 14.04 with PGDG Postgres packages. Any ideas?
Thanks,
Maciek
[1]: http://www.postgresql.org/docs/9.2/static/libpq-envars.html
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
