pgpool-II 3.7.5 with ssl

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pgpool-II 3.7.5 with ssl
Date: 2019-12-10 15:40:48
Message-ID: CAN6gwKytmFz__EvR8oqd1jYCpr9d91KnKLZUgim5wjgw=EuNSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

We use postgresql 9.6 and pgpool 3.7.5 and we are now asked to enable ssl
for 'in transit'. I have setup the ssl server side on the
postgresql dbs ( master and slave) and can see in pg_stat_ssl that the
master slave communication and connections from the application are showing
ssl = 't'

I have set the parameters in pgpool.conf as well but not sure if the pgpool
is working with ssl enabled. because when I try to connect
with psql using pgpool I get below:

[postgres(at)pgool-server ~]$ psql 'host=localhost port=5432 dbname=postgres
user=user1 sslmode=require'
psql: server does not support SSL, but SSL was required

Can you please advise on the above error, is the pgpool not supporting ssl
because it is not compiled with openssl? However, I can see
libssl.so.10 when I do 'ldd' on pgpool binary.

Best Regards
Vikas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-12-10 15:46:02 Re: A question about upgrading on Debian/Ubuntu
Previous Message Justin 2019-12-10 15:36:04 Re: tcp keep alive don't work when the backend is busy