Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Adrian Klaver
On 9/21/18 5:46 PM, Ravi Krishna wrote: First are doing a socket connection or a host connection? Socket connections ignore sslmode. The URL template of JDBC used by dbeaver is jdbc:postgresql://{host}[:{port}]/[{database}] From the manual "The host component is interpreted as described fo

Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Ravi Krishna
> First are doing a socket connection or a host connection? Socket > connections ignore sslmode. The URL template of JDBC used by dbeaver is jdbc:postgresql://{host}[:{port}]/[{database}] >From the manual "The host component is interpreted as described for the parameter host. In particular, a

Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Adrian Klaver
On 9/21/18 10:12 AM, Ravi Krishna wrote: We recently upgraded our JDBC driver to 42.2.5 after seeing this https://www.postgresql.org/about/news/1883/ All of our PG databases mandates SSL connections. So the first line in pg_hba.conf is hostnossl all all all reject We use dbeaver and while se

Re: New behavior with JDBC 42.2.5

2018-09-21 Thread Ravi Krishna
Just to clarify: With JDBC 42.1.4 attempt to connect from dbeaver without SSL results in the following error: "pg_hba.conf rejected the connection: SSL off" This is what we expect. With 42.2.5, the connection succeeds without SSL.

New behavior with JDBC 42.2.5

2018-09-21 Thread Ravi Krishna
We recently upgraded our JDBC driver to 42.2.5 after seeing this https://www.postgresql.org/about/news/1883/ All of our PG databases mandates SSL connections. So the first line in pg_hba.conf is hostnossl all all all reject We use dbeaver and while setting up connection we check box SSL (requi